BEGIN; BEGIN select nation, o_year, sum(amount) as sum_profit from ( select n_name as nation, extract(year from o_orderdate) as o_year, l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount from part, supplier, lineitem, partsupp, orders, nation where s_suppkey = l_suppkey and ps_suppkey = l_suppkey and ps_partkey = l_partkey and p_partkey = l_partkey and o_orderkey = l_orderkey and s_nationkey = n_nationkey and p_name like '%linen%' ) as profit group by nation, o_year order by nation, o_year desc; nation | o_year | sum_profit ---------------------------+--------+------------------ ALGERIA | 1998 | 258187538.426644 ALGERIA | 1997 | 448138230.369077 ALGERIA | 1996 | 456930041.621743 ALGERIA | 1995 | 455964842.831278 ALGERIA | 1994 | 446732381.674858 ALGERIA | 1993 | 453969639.113753 ALGERIA | 1992 | 449555606.021365 ARGENTINA | 1998 | 275657307.30518 ARGENTINA | 1997 | 471547229.717793 ARGENTINA | 1996 | 469709263.076893 ARGENTINA | 1995 | 474502282.833726 ARGENTINA | 1994 | 464472515.763823 ARGENTINA | 1993 | 474361731.369663 ARGENTINA | 1992 | 478004744.593185 BRAZIL | 1998 | 277604127.656323 BRAZIL | 1997 | 470087347.322279 BRAZIL | 1996 | 461480293.588383 BRAZIL | 1995 | 463528601.697699 BRAZIL | 1994 | 464201396.392967 BRAZIL | 1993 | 461201961.867568 BRAZIL | 1992 | 467606006.91275 CANADA | 1998 | 272144404.409871 CANADA | 1997 | 476511937.59147 CANADA | 1996 | 475277418.942248 CANADA | 1995 | 472449169.116573 CANADA | 1994 | 473484159.422683 CANADA | 1993 | 474684279.17651 CANADA | 1992 | 471201385.204917 CHINA | 1998 | 272344365.207174 CHINA | 1997 | 464989466.153742 CHINA | 1996 | 464333876.315466 CHINA | 1995 | 461071732.423246 CHINA | 1994 | 463474173.484894 CHINA | 1993 | 465103111.024772 CHINA | 1992 | 470742734.985175 EGYPT | 1998 | 271414326.141942 EGYPT | 1997 | 458331228.123701 EGYPT | 1996 | 470886698.131044 EGYPT | 1995 | 463053788.832868 EGYPT | 1994 | 462718806.496246 EGYPT | 1993 | 459220498.879604 EGYPT | 1992 | 469044431.962568 ETHIOPIA | 1998 | 264594161.397802 ETHIOPIA | 1997 | 450856158.706936 ETHIOPIA | 1996 | 441348806.718255 ETHIOPIA | 1995 | 451861173.790823 ETHIOPIA | 1994 | 456179439.878368 ETHIOPIA | 1993 | 447598254.603394 ETHIOPIA | 1992 | 457173639.002553 FRANCE | 1998 | 263158718.846576 FRANCE | 1997 | 453178040.07202 FRANCE | 1996 | 447304788.868506 FRANCE | 1995 | 445269628.637485 FRANCE | 1994 | 453455976.023405 FRANCE | 1993 | 453162241.360894 FRANCE | 1992 | 459137668.683274 GERMANY | 1998 | 278923161.615443 GERMANY | 1997 | 470157585.30675 GERMANY | 1996 | 474338858.786471 GERMANY | 1995 | 471465108.299251 GERMANY | 1994 | 478762604.249111 GERMANY | 1993 | 477812724.174098 GERMANY | 1992 | 470454178.060662 INDIA | 1998 | 279910710.261211 INDIA | 1997 | 474773974.909139 INDIA | 1996 | 476069983.318326 INDIA | 1995 | 472457092.796186 INDIA | 1994 | 479656801.634061 INDIA | 1993 | 476887433.472883 INDIA | 1992 | 482260378.289733 INDONESIA | 1998 | 273937804.479783 INDONESIA | 1997 | 463008697.940276 INDONESIA | 1996 | 464162682.082979 INDONESIA | 1995 | 459957708.924827 INDONESIA | 1994 | 462002943.357472 INDONESIA | 1993 | 457950006.477611 INDONESIA | 1992 | 457177942.723031 IRAN | 1998 | 273183760.654011 IRAN | 1997 | 459124839.66508 IRAN | 1996 | 469635913.438628 IRAN | 1995 | 473101947.050424 IRAN | 1994 | 468622984.848288 IRAN | 1993 | 467399451.356824 IRAN | 1992 | 468433106.070511 IRAQ | 1998 | 276968374.334929 IRAQ | 1997 | 474419819.955477 IRAQ | 1996 | 476438559.076042 IRAQ | 1995 | 477756948.766102 IRAQ | 1994 | 474365567.309624 IRAQ | 1993 | 477762407.530027 IRAQ | 1992 | 468281659.251618 JAPAN | 1998 | 268782961.56928 JAPAN | 1997 | 464582271.939884 JAPAN | 1996 | 460093970.578487 JAPAN | 1995 | 455692845.325669 JAPAN | 1994 | 463882554.298937 JAPAN | 1993 | 458055108.181751 JAPAN | 1992 | 454734188.391407 JORDAN | 1998 | 273755428.147074 JORDAN | 1997 | 459547284.999891 JORDAN | 1996 | 460934821.587993 JORDAN | 1995 | 463200726.620708 JORDAN | 1994 | 460858252.542098 JORDAN | 1993 | 462514153.885824 JORDAN | 1992 | 464529146.912576 KENYA | 1998 | 267405947.337191 KENYA | 1997 | 463551941.905097 KENYA | 1996 | 472472757.020617 KENYA | 1995 | 466845137.568779 KENYA | 1994 | 470050876.914985 KENYA | 1993 | 464654122.291818 KENYA | 1992 | 461605085.045264 MOROCCO | 1998 | 270507610.881712 MOROCCO | 1997 | 458384788.2123 MOROCCO | 1996 | 469998841.47882 MOROCCO | 1995 | 454546845.730812 MOROCCO | 1994 | 456286508.040229 MOROCCO | 1993 | 459029166.546287 MOROCCO | 1992 | 471939548.189153 MOZAMBIQUE | 1998 | 272931993.128145 MOZAMBIQUE | 1997 | 465396081.250877 MOZAMBIQUE | 1996 | 463768499.867359 MOZAMBIQUE | 1995 | 465268051.448627 MOZAMBIQUE | 1994 | 460652321.53648 MOZAMBIQUE | 1993 | 467403908.699074 MOZAMBIQUE | 1992 | 458162391.211268 PERU | 1998 | 268977946.210417 PERU | 1997 | 468405740.331755 PERU | 1996 | 464568526.944062 PERU | 1995 | 472396268.695167 PERU | 1994 | 468216183.792162 PERU | 1993 | 464218456.236896 PERU | 1992 | 478123273.466454 ROMANIA | 1998 | 275733943.104078 ROMANIA | 1997 | 461360464.056803 ROMANIA | 1996 | 476985147.807505 ROMANIA | 1995 | 469248966.461026 ROMANIA | 1994 | 474201345.196022 ROMANIA | 1993 | 465334920.145836 ROMANIA | 1992 | 466998700.051908 RUSSIA | 1998 | 270674110.265904 RUSSIA | 1997 | 467101300.905526 RUSSIA | 1996 | 464545889.565965 RUSSIA | 1995 | 464716082.487057 RUSSIA | 1994 | 457228863.114842 RUSSIA | 1993 | 460504544.202931 RUSSIA | 1992 | 468627868.594074 SAUDI ARABIA | 1998 | 273567610.085337 SAUDI ARABIA | 1997 | 463885932.414397 SAUDI ARABIA | 1996 | 472951149.998725 SAUDI ARABIA | 1995 | 470634074.127413 SAUDI ARABIA | 1994 | 460551062.94562 SAUDI ARABIA | 1993 | 469256129.081445 SAUDI ARABIA | 1992 | 464407691.450733 UNITED KINGDOM | 1998 | 273776163.501409 UNITED KINGDOM | 1997 | 472527456.699201 UNITED KINGDOM | 1996 | 466792441.862461 UNITED KINGDOM | 1995 | 466385367.968005 UNITED KINGDOM | 1994 | 463110767.854942 UNITED KINGDOM | 1993 | 455334145.71771 UNITED KINGDOM | 1992 | 461900157.951113 UNITED STATES | 1998 | 278955006.356946 UNITED STATES | 1997 | 467431947.248276 UNITED STATES | 1996 | 471695763.665363 UNITED STATES | 1995 | 474505800.059189 UNITED STATES | 1994 | 480938092.819494 UNITED STATES | 1993 | 470510187.54399 UNITED STATES | 1992 | 473719919.40326 VIETNAM | 1998 | 274821239.772303 VIETNAM | 1997 | 463772782.523969 VIETNAM | 1996 | 473930663.16794 VIETNAM | 1995 | 462990858.84707 VIETNAM | 1994 | 469056062.601826 VIETNAM | 1993 | 469340863.04929 VIETNAM | 1992 | 469232030.013852 (175 rows) COMMIT; COMMIT