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 '%burlywood%' ) as profit group by nation, o_year order by nation, o_year desc; nation | o_year | sum_profit ---------------------------+--------+------------------ ALGERIA | 1998 | 264876193.54639 ALGERIA | 1997 | 456121905.275913 ALGERIA | 1996 | 453403962.331325 ALGERIA | 1995 | 463259840.624844 ALGERIA | 1994 | 452653945.023701 ALGERIA | 1993 | 458670202.806219 ALGERIA | 1992 | 454989293.608625 ARGENTINA | 1998 | 268761158.843565 ARGENTINA | 1997 | 463573863.70044 ARGENTINA | 1996 | 461511312.318551 ARGENTINA | 1995 | 469349487.048365 ARGENTINA | 1994 | 463549020.61102 ARGENTINA | 1993 | 468475849.448892 ARGENTINA | 1992 | 457530840.11456 BRAZIL | 1998 | 278086135.86794 BRAZIL | 1997 | 469359432.976039 BRAZIL | 1996 | 468742234.662962 BRAZIL | 1995 | 474120744.148588 BRAZIL | 1994 | 460646740.057875 BRAZIL | 1993 | 471306324.743654 BRAZIL | 1992 | 470280980.277097 CANADA | 1998 | 276265466.614068 CANADA | 1997 | 474197021.349583 CANADA | 1996 | 475810374.293013 CANADA | 1995 | 481842863.222703 CANADA | 1994 | 481976870.582948 CANADA | 1993 | 472401754.403411 CANADA | 1992 | 468583188.057196 CHINA | 1998 | 270350720.433561 CHINA | 1997 | 461512921.815384 CHINA | 1996 | 469951521.201221 CHINA | 1995 | 460093070.001608 CHINA | 1994 | 465755552.016641 CHINA | 1993 | 457106422.592822 CHINA | 1992 | 457763839.912622 EGYPT | 1998 | 265498911.124627 EGYPT | 1997 | 466129464.481056 EGYPT | 1996 | 461657724.157304 EGYPT | 1995 | 451481392.961429 EGYPT | 1994 | 460179722.611613 EGYPT | 1993 | 456420113.702578 EGYPT | 1992 | 460430879.114147 ETHIOPIA | 1998 | 263393278.261006 ETHIOPIA | 1997 | 454885562.485661 ETHIOPIA | 1996 | 460535615.809611 ETHIOPIA | 1995 | 458372501.742953 ETHIOPIA | 1994 | 458062183.702748 ETHIOPIA | 1993 | 462845872.358624 ETHIOPIA | 1992 | 458527893.455356 FRANCE | 1998 | 264307278.400471 FRANCE | 1997 | 453638421.36303 FRANCE | 1996 | 466299308.296635 FRANCE | 1995 | 462142603.497156 FRANCE | 1994 | 454812398.309521 FRANCE | 1993 | 458358126.93594 FRANCE | 1992 | 470410368.447104 GERMANY | 1998 | 282552108.422194 GERMANY | 1997 | 480117721.328878 GERMANY | 1996 | 475210004.67703 GERMANY | 1995 | 468540912.785061 GERMANY | 1994 | 473046337.639345 GERMANY | 1993 | 479185063.691945 GERMANY | 1992 | 478748311.150808 INDIA | 1998 | 277680866.12372 INDIA | 1997 | 472769474.17779 INDIA | 1996 | 479059051.883431 INDIA | 1995 | 469766032.376034 INDIA | 1994 | 476544524.015971 INDIA | 1993 | 475146811.281552 INDIA | 1992 | 471399200.205996 INDONESIA | 1998 | 276455959.315687 INDONESIA | 1997 | 461646794.959165 INDONESIA | 1996 | 463345560.567513 INDONESIA | 1995 | 465204237.211766 INDONESIA | 1994 | 466740487.477978 INDONESIA | 1993 | 460142912.388546 INDONESIA | 1992 | 461259490.954784 IRAN | 1998 | 270514543.499105 IRAN | 1997 | 455044167.632479 IRAN | 1996 | 447795067.750794 IRAN | 1995 | 462929963.952197 IRAN | 1994 | 455756232.347076 IRAN | 1993 | 450820095.421548 IRAN | 1992 | 459921763.841907 IRAQ | 1998 | 274759403.029624 IRAQ | 1997 | 472063566.435291 IRAQ | 1996 | 469845933.609465 IRAQ | 1995 | 471922313.987886 IRAQ | 1994 | 473189283.99475 IRAQ | 1993 | 470011484.325538 IRAQ | 1992 | 471071057.412598 JAPAN | 1998 | 274409652.638451 JAPAN | 1997 | 466008976.367296 JAPAN | 1996 | 471586088.078304 JAPAN | 1995 | 462777285.629605 JAPAN | 1994 | 473334840.141115 JAPAN | 1993 | 468890305.550846 JAPAN | 1992 | 461843232.446707 JORDAN | 1998 | 270290706.470208 JORDAN | 1997 | 459662910.088575 JORDAN | 1996 | 457659679.611859 JORDAN | 1995 | 461577153.678276 JORDAN | 1994 | 457987366.870105 JORDAN | 1993 | 467271926.824908 JORDAN | 1992 | 461055177.173429 KENYA | 1998 | 272897040.254549 KENYA | 1997 | 469753351.949338 KENYA | 1996 | 469383400.145945 KENYA | 1995 | 470567922.221445 KENYA | 1994 | 472160431.608472 KENYA | 1993 | 470445783.662083 KENYA | 1992 | 472174865.136713 MOROCCO | 1998 | 278907707.185667 MOROCCO | 1997 | 474130710.879286 MOROCCO | 1996 | 477630683.17626 MOROCCO | 1995 | 468819421.997631 MOROCCO | 1994 | 473599797.082097 MOROCCO | 1993 | 471613014.712309 MOROCCO | 1992 | 476260576.794476 MOZAMBIQUE | 1998 | 275871353.519478 MOZAMBIQUE | 1997 | 463889713.456541 MOZAMBIQUE | 1996 | 458371397.491174 MOZAMBIQUE | 1995 | 463539854.176168 MOZAMBIQUE | 1994 | 455665082.088703 MOZAMBIQUE | 1993 | 455791094.178657 MOZAMBIQUE | 1992 | 461743323.0119 PERU | 1998 | 264704211.152717 PERU | 1997 | 461472475.796583 PERU | 1996 | 463913241.947655 PERU | 1995 | 455344264.394383 PERU | 1994 | 455253549.850347 PERU | 1993 | 449735997.166919 PERU | 1992 | 451868391.787322 ROMANIA | 1998 | 271046119.279763 ROMANIA | 1997 | 463011571.19331 ROMANIA | 1996 | 464114407.702318 ROMANIA | 1995 | 463864047.121222 ROMANIA | 1994 | 469534684.049083 ROMANIA | 1993 | 463216195.282189 ROMANIA | 1992 | 470827589.324039 RUSSIA | 1998 | 274482366.730088 RUSSIA | 1997 | 466390497.285743 RUSSIA | 1996 | 463960962.423061 RUSSIA | 1995 | 469806494.013051 RUSSIA | 1994 | 463675148.983087 RUSSIA | 1993 | 464561640.270154 RUSSIA | 1992 | 468710888.344856 SAUDI ARABIA | 1998 | 277747474.760459 SAUDI ARABIA | 1997 | 461587962.615686 SAUDI ARABIA | 1996 | 461445312.290008 SAUDI ARABIA | 1995 | 464824184.007723 SAUDI ARABIA | 1994 | 462982363.836255 SAUDI ARABIA | 1993 | 461817434.607754 SAUDI ARABIA | 1992 | 462115545.392434 UNITED KINGDOM | 1998 | 265997591.483833 UNITED KINGDOM | 1997 | 456574197.433601 UNITED KINGDOM | 1996 | 454776211.608632 UNITED KINGDOM | 1995 | 456382207.892605 UNITED KINGDOM | 1994 | 449120954.341306 UNITED KINGDOM | 1993 | 451975330.178429 UNITED KINGDOM | 1992 | 455229466.274678 UNITED STATES | 1998 | 279210741.402467 UNITED STATES | 1997 | 473074359.154951 UNITED STATES | 1996 | 474537808.236426 UNITED STATES | 1995 | 474107511.751287 UNITED STATES | 1994 | 480228927.221893 UNITED STATES | 1993 | 475116285.244602 UNITED STATES | 1992 | 474790853.958772 VIETNAM | 1998 | 274776116.693917 VIETNAM | 1997 | 461347371.716647 VIETNAM | 1996 | 470671807.851545 VIETNAM | 1995 | 459466297.235311 VIETNAM | 1994 | 466030527.644518 VIETNAM | 1993 | 465789052.649269 VIETNAM | 1992 | 469118075.677704 (175 rows) COMMIT; COMMIT