SQL Editor

Tables and Columns 

Problem:

List the orders for the year 2013. Include the lowest and highest sales amount for each month.
Click here for details on LAST_VALUE.
 
 408 Records
Month Customer Lowest Monthly Sale TotalAmount Highest Monthly Sale
1 Jean Fresnière 49.80 11493.20 11493.20
1 Jytte Petersen 49.80 11283.20 11493.20
1 Roland Mendel 49.80 5796.00 11493.20
1 Paula Wilson 49.80 3868.60 11493.20
1 Ann Devon 49.80 3063.00 11493.20
1 Roland Mendel 49.80 2713.50 11493.20
1 Elizabeth Lincoln 49.80 2523.00 11493.20
1 Michael Holz 49.80 2208.00 11493.20
1 Annette Roulet 49.80 2123.20 11493.20
1 Lúcia Carvalho 49.80 2018.20 11493.20
1 Paula Parente 49.80 1897.60 11493.20
1 Horst Kloss 49.80 1814.80 11493.20
1 Patricia McKenna 49.80 1748.50 11493.20
1 Giovanni Rovelli 49.80 1675.00 11493.20
1 Martine Rancé 49.80 1622.40 11493.20
1 Bernardo Batista 49.80 1273.20 11493.20
1 Elizabeth Lincoln 49.80 1208.50 11493.20
1 Henriette Pfalzheim 49.80 1194.00 11493.20
1 André Fonseca 49.80 1020.00 11493.20
1 Roland Mendel 49.80 1005.90 11493.20
1 Elizabeth Lincoln 49.80 802.00 11493.20
1 Pirkko Koskitalo 49.80 720.00 11493.20
1 Georg Pipps 49.80 651.00 11493.20
1 Art Braunschweiger 49.80 485.00 11493.20
1 Annette Roulet 49.80 480.00 11493.20
1 Felipe Izquierdo 49.80 400.00 11493.20
1 Pirkko Koskitalo 49.80 372.00 11493.20
1 Eduardo Saavedra 49.80 338.20 11493.20
1 Yvonne Moncada 49.80 319.20 11493.20
1 Aria Cruz 49.80 231.40 11493.20
1 Maurizio Moroni 49.80 192.00 11493.20
1 Yoshi Latimer 49.80 102.40 11493.20
1 Paolo Accorti 49.80 49.80 11493.20
2 Jose Pavarotti 174.90 5793.10 5793.10
2 Horst Kloss 174.90 4277.40 5793.10
2 Pascale Cartrain 174.90 3891.00 5793.10
2 Pirkko Koskitalo 174.90 2684.00 5793.10
2 Frédérique Citeaux 174.90 2210.80 5793.10
2 Jose Pavarotti 174.90 2096.00 5793.10
2 Carlos González 174.90 2051.60 5793.10
2 Frédérique Citeaux 174.90 1838.20 5793.10
2 Roland Mendel 174.90 1792.00 5793.10
2 Rene Phillips 174.90 1755.00 5793.10
2 Mary Saveley 174.90 1688.00 5793.10
2 Philip Cramer 174.90 1584.00 5793.10
2 Jean Fresnière 174.90 1078.00 5793.10
2 Christina Berglund 174.90 1031.70 5793.10
2 Janete Limeira 174.90 914.40 5793.10
2 Isabel de Castro 174.90 851.20 5793.10
2 Philip Cramer 174.90 656.00 5793.10
2 Elizabeth Brown 174.90 631.60 5793.10
2 Karin Josephs 174.90 567.50 5793.10
2 Maurizio Moroni 174.90 537.60 5793.10
2 Mary Saveley 174.90 531.40 5793.10
2 Thomas Hardy 174.90 453.00 5793.10
2 Sergio Gutiérrez 174.90 443.40 5793.10
2 Annette Roulet 174.90 414.00 5793.10
2 Pirkko Koskitalo 174.90 393.00 5793.10
2 Maria Larsson 174.90 360.00 5793.10
2 Karin Josephs 174.90 273.60 5793.10
2 Maria Larsson 174.90 234.80 5793.10
2 Christina Berglund 174.90 174.90 5793.10
3 Paula Wilson 147.00 10495.60 10495.60
3 Carlos Hernández 147.00 3163.20 10495.60
3 Palle Ibsen 147.00 2719.00 10495.60
3 Lino Rodriguez 147.00 1848.00 10495.60
3 Laurence Lebihan 147.00 1820.80 10495.60
3 Pascale Cartrain 147.00 1770.80 10495.60
3 Felipe Izquierdo 147.00 1760.00 10495.60
3 Peter Franken 147.00 1560.00 10495.60
3 Janete Limeira 147.00 1472.00 10495.60
3 Victoria Ashworth 147.00 1328.00 10495.60
3 Carlos Hernández 147.00 1272.00 10495.60
3 Guillermo Fernández 147.00 1249.10 10495.60
3 Karl Jablonski 147.00 1125.50 10495.60
3 Hari Kumar 147.00 1051.20 10495.60
3 Lúcia Carvalho 147.00 925.10 10495.60
3 Martine Rancé 147.00 756.00 10495.60
3 Philip Cramer 147.00 717.60 10495.60
3 Pascale Cartrain 147.00 713.30 10495.60
3 Karl Jablonski 147.00 704.00 10495.60
3 Isabel de Castro 147.00 672.00 10495.60
3 Georg Pipps 147.00 502.20 10495.60
3 Mary Saveley 147.00 496.00 10495.60
3 Victoria Ashworth 147.00 386.20 10495.60
3 Lino Rodriguez 147.00 305.30 10495.60
3 Giovanni Rovelli 147.00 235.20 10495.60
3 Helen Bennett 147.00 230.40 10495.60
3 Pedro Afonso 147.00 216.00 10495.60
3 Carlos Hernández 147.00 182.40 10495.60
3 Elizabeth Brown 147.00 156.00 10495.60
3 John Steel 147.00 147.00 10495.60
4 Horst Kloss 136.80 10588.50 10588.50
4 Roland Mendel 136.80 8623.45 10588.50
4 Jose Pavarotti 136.80 4735.44 10588.50
4 Miguel Angel Paolino 136.80 4150.05 10588.50
4 Laurence Lebihan 136.80 3000.00 10588.50
4 Renate Messner 136.80 2657.80 10588.50
4 Patricia McKenna 136.80 2614.50 10588.50
4 Rita Müller 136.80 2427.50 10588.50
4 Yang Wang 136.80 2356.00 10588.50
4 Patricia McKenna 136.80 2048.50 10588.50
4 Carlos González 136.80 1412.00 10588.50
4 Karl Jablonski 136.80 1388.50 10588.50
4 Renate Messner 136.80 1380.60 10588.50
4 Pedro Afonso 136.80 912.00 10588.50
4 Elizabeth Lincoln 136.80 896.00 10588.50
4 Antonio Moreno 136.80 881.25 10588.50
4 Guillermo Fernández 136.80 816.30 10588.50
4 Annette Roulet 136.80 676.00 10588.50
4 Aria Cruz 136.80 618.00 10588.50
4 Carlos Hernández 136.80 575.00 10588.50
4 Annette Roulet 136.80 550.80 10588.50
4 Philip Cramer 136.80 462.00 10588.50
4 Simon Crowther 136.80 352.00 10588.50
4 Yoshi Tannamuri 136.80 278.00 10588.50
4 Henriette Pfalzheim 136.80 240.00 10588.50
4 Patricio Simpson 136.80 225.50 10588.50
4 Jonas Bergulfsen 136.80 200.00 10588.50
4 Anabela Domingues 136.80 200.00 10588.50
4 Hanna Moos 136.80 149.00 10588.50
4 Jean Fresnière 136.80 147.90 10588.50
4 Hanna Moos 136.80 136.80 10588.50
5 Horst Kloss 110.00 10191.70 10191.70
5 Horst Kloss 110.00 4181.50 10191.70
5 Georg Pipps 110.00 4180.00 10191.70
5 Christina Berglund 110.00 3192.65 10191.70
5 Mary Saveley 110.00 2812.00 10191.70
5 Hari Kumar 110.00 2715.90 10191.70
5 Maria Larsson 110.00 2295.20 10191.70
5 Mario Pontes 110.00 2162.80 10191.70
5 Antonio Moreno 110.00 2156.50 10191.70
5 Renate Messner 110.00 2085.00 10191.70
5 Hari Kumar 110.00 1908.00 10191.70
5 Lino Rodriguez 110.00 1836.00 10191.70
5 Michael Holz 110.00 1823.80 10191.70
5 Henriette Pfalzheim 110.00 1819.50 10191.70
5 Carlos González 110.00 1770.00 10191.70
5 Horst Kloss 110.00 1670.00 10191.70
5 Pirkko Koskitalo 110.00 1546.30 10191.70
5 Pirkko Koskitalo 110.00 1344.00 10191.70
5 Catherine Dewey 110.00 946.00 10191.70
5 Carlos Hernández 110.00 880.50 10191.70
5 Laurence Lebihan 110.00 846.00 10191.70
5 Ann Devon 110.00 796.35 10191.70
5 José Pedro Freyre 110.00 749.00 10191.70
5 Renate Messner 110.00 517.40 10191.70
5 Philip Cramer 110.00 493.80 10191.70
5 Fran Wilson 110.00 417.20 10191.70
5 Howard Snyder 110.00 396.20 10191.70
5 Victoria Ashworth 110.00 355.50 10191.70
5 Karin Josephs 110.00 275.10 10191.70
5 John Steel 110.00 210.00 10191.70
5 Victoria Ashworth 110.00 139.80 10191.70
5 Yvonne Moncada 110.00 110.00 10191.70
6 Jose Pavarotti 155.00 3680.50 3680.50
6 Patricia McKenna 155.00 3109.00 3680.50
6 Maria Larsson 155.00 2844.50 3680.50
6 Jean Fresnière 155.00 2595.00 3680.50
6 Pirkko Koskitalo 155.00 2413.90 3680.50
6 Alexander Feuer 155.00 2147.40 3680.50
6 Thomas Hardy 155.00 2142.90 3680.50
6 Antonio Moreno 155.00 2082.00 3680.50
6 Frédérique Citeaux 155.00 2040.00 3680.50
6 Christina Berglund 155.00 1565.65 3680.50
6 Paula Wilson 155.00 1299.00 3680.50
6 Peter Franken 155.00 1257.30 3680.50
6 Renate Messner 155.00 1152.50 3680.50
6 Henriette Pfalzheim 155.00 1067.10 3680.50
6 Paula Wilson 155.00 977.50 3680.50
6 Janete Limeira 155.00 965.00 3680.50
6 Miguel Angel Paolino 155.00 838.45 3680.50
6 Jytte Petersen 155.00 835.20 3680.50
6 Helvetius Nagy 155.00 764.30 3680.50
6 Jean Fresnière 155.00 711.00 3680.50
6 Roland Mendel 155.00 647.75 3680.50
6 Frédérique Citeaux 155.00 625.00 3680.50
6 Helvetius Nagy 155.00 569.00 3680.50
6 Frédérique Citeaux 155.00 547.80 3680.50
6 Maurizio Moroni 155.00 543.00 3680.50
6 Victoria Ashworth 155.00 477.00 3680.50
6 Aria Cruz 155.00 387.50 3680.50
6 Hanna Moos 155.00 330.00 3680.50
6 Jaime Yorres 155.00 317.75 3680.50
6 Eduardo Saavedra 155.00 155.00 3680.50
7 Jose Pavarotti 28.00 6475.40 6475.40
7 Jose Pavarotti 28.00 6375.00 6475.40
7 Roland Mendel 28.00 6300.00 6475.40
7 Howard Snyder 28.00 5032.00 6475.40
7 Jean Fresnière 28.00 4326.00 6475.40
7 Horst Kloss 28.00 3900.00 6475.40
7 Renate Messner 28.00 2493.00 6475.40
7 Paula Wilson 28.00 2388.50 6475.40
7 Carlos Hernández 28.00 2285.00 6475.40
7 Howard Snyder 28.00 1650.00 6475.40
7 Jose Pavarotti 28.00 1508.00 6475.40
7 Karl Jablonski 28.00 1476.10 6475.40
7 Anabela Domingues 28.00 1413.00 6475.40
7 Jean Fresnière 28.00 1140.00 6475.40
7 Karin Josephs 28.00 1064.00 6475.40
7 Palle Ibsen 28.00 812.50 6475.40
7 Zbyszek Piestrzeniewicz 28.00 808.00 6475.40
7 Bernardo Batista 28.00 807.38 6475.40
7 Georg Pipps 28.00 800.10 6475.40
7 Rene Phillips 28.00 565.50 6475.40
7 Renate Messner 28.00 543.65 6475.40
7 Victoria Ashworth 28.00 493.00 6475.40
7 Yoshi Latimer 28.00 479.80 6475.40
7 Hanna Moos 28.00 464.00 6475.40
7 Janine Labrune 28.00 424.00 6475.40
7 Annette Roulet 28.00 399.00 6475.40
7 Carlos Hernández 28.00 358.00 6475.40
7 Lino Rodriguez 28.00 256.50 6475.40
7 Paula Parente 28.00 142.50 6475.40
7 Matti Karttunen 28.00 120.00 6475.40
7 Howard Snyder 28.00 72.00 6475.40
7 Palle Ibsen 28.00 65.00 6475.40
7 Maurizio Moroni 28.00 28.00 6475.40
8 Roland Mendel 57.50 6483.05 6483.05
8 Martine Rancé 57.50 4985.50 6483.05
8 Lúcia Carvalho 57.50 2896.25 6483.05
8 José Pedro Freyre 57.50 2775.05 6483.05
8 Felipe Izquierdo 57.50 2720.05 6483.05
8 Jean Fresnière 57.50 2697.50 6483.05
8 Carlos Hernández 57.50 2054.00 6483.05
8 Patricia McKenna 57.50 1928.00 6483.05
8 Aria Cruz 57.50 1820.20 6483.05
8 Mario Pontes 57.50 1535.00 6483.05
8 Christina Berglund 57.50 1503.60 6483.05
8 Catherine Dewey 57.50 1434.00 6483.05
8 Peter Franken 57.50 1429.75 6483.05
8 Paula Parente 57.50 1422.00 6483.05
8 Liu Wong 57.50 1393.24 6483.05
8 Giovanni Rovelli 57.50 1380.25 6483.05
8 Jose Pavarotti 57.50 1264.50 6483.05
8 Jean Fresnière 57.50 1260.00 6483.05
8 Maria Anders 57.50 1086.00 6483.05
8 Rita Müller 57.50 945.00 6483.05
8 Philip Cramer 57.50 918.00 6483.05
8 Jytte Petersen 57.50 870.00 6483.05
8 Helen Bennett 57.50 758.50 6483.05
8 Bernardo Batista 57.50 636.00 6483.05
8 Pirkko Koskitalo 57.50 629.50 6483.05
8 Rita Müller 57.50 620.00 6483.05
8 Janete Limeira 57.50 605.00 6483.05
8 Jonas Bergulfsen 57.50 500.00 6483.05
8 Ana Trujillo 57.50 479.75 6483.05
8 Frédérique Citeaux 57.50 450.00 6483.05
8 Janete Limeira 57.50 382.50 6483.05
8 Annette Roulet 57.50 62.00 6483.05
8 Yoshi Tannamuri 57.50 57.50 6483.05
9 Patricia McKenna 45.00 6201.90 6201.90
9 Jose Pavarotti 45.00 5256.50 6201.90
9 Horst Kloss 45.00 4668.00 6201.90
9 Michael Holz 45.00 4666.94 6201.90
9 Jose Pavarotti 45.00 4371.60 6201.90
9 Christina Berglund 45.00 4210.50 6201.90
9 Peter Franken 45.00 2301.75 6201.90
9 Laurence Lebihan 45.00 2032.00 6201.90
9 Roland Mendel 45.00 1921.00 6201.90
9 Henriette Pfalzheim 45.00 1768.00 6201.90
9 Yoshi Latimer 45.00 1701.00 6201.90
9 Rene Phillips 45.00 1682.50 6201.90
9 Georg Pipps 45.00 1638.45 6201.90
9 Lino Rodriguez 45.00 1515.75 6201.90
9 Peter Franken 45.00 1423.00 6201.90
9 Howard Snyder 45.00 1327.00 6201.90
9 Fran Wilson 45.00 1295.00 6201.90
9 Lúcia Carvalho 45.00 1291.60 6201.90
9 Peter Franken 45.00 1203.50 6201.90
9 Antonio Moreno 45.00 956.90 6201.90
9 Carine Schmitt 45.00 920.10 6201.90
9 André Fonseca 45.00 801.10 6201.90
9 Patricia McKenna 45.00 703.25 6201.90
9 Rita Müller 45.00 694.75 6201.90
9 Howard Snyder 45.00 671.35 6201.90
9 Christina Berglund 45.00 668.70 6201.90
9 Frédérique Citeaux 45.00 660.00 6201.90
9 Jytte Petersen 45.00 570.00 6201.90
9 Miguel Angel Paolino 45.00 534.85 6201.90
9 Rita Müller 45.00 530.40 6201.90
9 Matti Karttunen 45.00 412.35 6201.90
9 Antonio Moreno 45.00 375.50 6201.90
9 André Fonseca 45.00 331.78 6201.90
9 Maurizio Moroni 45.00 193.00 6201.90
9 Fran Wilson 45.00 125.00 6201.90
9 Janine Labrune 45.00 63.00 6201.90
9 Helen Bennett 45.00 45.00 6201.90
10 Horst Kloss 93.50 10164.80 10164.80
10 Horst Kloss 93.50 4825.00 10164.80
10 Jose Pavarotti 93.50 4451.70 10164.80
10 Roland Mendel 93.50 3600.73 10164.80
10 Palle Ibsen 93.50 3490.00 10164.80
10 Philip Cramer 93.50 3463.00 10164.80
10 André Fonseca 93.50 3424.00 10164.80
10 Patricia McKenna 93.50 3370.00 10164.80
10 Jose Pavarotti 93.50 2941.00 10164.80
10 Jose Pavarotti 93.50 2827.90 10164.80
10 Maria Larsson 93.50 2545.00 10164.80
10 Karl Jablonski 93.50 2334.00 10164.80
10 Jose Pavarotti 93.50 2048.00 10164.80
10 Rene Phillips 93.50 1893.00 10164.80
10 Thomas Hardy 93.50 1704.00 10164.80
10 Jose Pavarotti 93.50 1570.00 10164.80
10 Peter Franken 93.50 1331.75 10164.80
10 Laurence Lebihan 93.50 1296.00 10164.80
10 Patricia McKenna 93.50 1238.40 10164.80
10 Mario Pontes 93.50 1150.00 10164.80
10 Jaime Yorres 93.50 1125.67 10164.80
10 Felipe Izquierdo 93.50 1073.90 10164.80
10 Karl Jablonski 93.50 996.00 10164.80
10 Horst Kloss 93.50 972.50 10164.80
10 Maria Anders 93.50 878.00 10164.80
10 Sergio Gutiérrez 93.50 706.00 10164.80
10 Matti Karttunen 93.50 642.00 10164.80
10 Jean Fresnière 93.50 638.50 10164.80
10 Christina Berglund 93.50 630.00 10164.80
10 Lúcia Carvalho 93.50 595.50 10164.80
10 Bernardo Batista 93.50 550.00 10164.80
10 Karl Jablonski 93.50 468.45 10164.80
10 Carlos Hernández 93.50 378.00 10164.80
10 Maria Anders 93.50 330.00 10164.80
10 Aria Cruz 93.50 287.80 10164.80
10 Liz Nixon 93.50 180.40 10164.80
10 Alexander Feuer 93.50 114.00 10164.80
10 Paolo Accorti 93.50 93.50 10164.80
11 Horst Kloss 52.35 4529.80 4529.80
11 Elizabeth Lincoln 52.35 3118.00 4529.80
11 Jose Pavarotti 52.35 3082.00 4529.80
11 Laurence Lebihan 52.35 2598.00 4529.80
11 Art Braunschweiger 52.35 2487.50 4529.80
11 Yang Wang 52.35 2311.70 4529.80
11 Jose Pavarotti 52.35 2196.00 4529.80
11 Yang Wang 52.35 1990.00 4529.80
11 Georg Pipps 52.35 1912.85 4529.80
11 Pirkko Koskitalo 52.35 1871.25 4529.80
11 Felipe Izquierdo 52.35 1850.00 4529.80
11 Karl Jablonski 52.35 1770.00 4529.80
11 Maurizio Moroni 52.35 1710.00 4529.80
11 Michael Holz 52.35 1701.46 4529.80
11 Michael Holz 52.35 1644.60 4529.80
11 André Fonseca 52.35 1498.35 4529.80
11 Christina Berglund 52.35 1459.00 4529.80
11 Lúcia Carvalho 52.35 1296.75 4529.80
11 Helen Bennett 52.35 1080.00 4529.80
11 Patricia McKenna 52.35 997.00 4529.80
11 Palle Ibsen 52.35 920.00 4529.80
11 Ann Devon 52.35 655.00 4529.80
11 Jaime Yorres 52.35 596.00 4529.80
11 Laurence Lebihan 52.35 509.75 4529.80
11 Laurence Lebihan 52.35 360.00 4529.80
11 Thomas Hardy 52.35 336.00 4529.80
11 Ana Trujillo 52.35 320.00 4529.80
11 Thomas Hardy 52.35 285.00 4529.80
11 Simon Crowther 52.35 252.00 4529.80
11 Paul Henriot 52.35 240.00 4529.80
11 Paul Henriot 52.35 139.80 4529.80
11 Paolo Accorti 52.35 88.00 4529.80
11 Giovanni Rovelli 52.35 55.20 4529.80
11 Dominique Perrier 52.35 52.35 4529.80
12 Roland Mendel 12.50 6984.50 6984.50
12 Maria Larsson 12.50 4337.00 6984.50
12 Martín Sommer 12.50 4035.80 6984.50
12 Jytte Petersen 12.50 3923.75 6984.50
12 Martine Rancé 12.50 3687.00 6984.50
12 Renate Messner 12.50 3603.22 6984.50
12 Catherine Dewey 12.50 3304.00 6984.50
12 Carlos Hernández 12.50 2878.08 6984.50
12 Liz Nixon 12.50 2775.00 6984.50
12 Annette Roulet 12.50 2760.80 6984.50
12 Roland Mendel 12.50 2540.00 6984.50
12 Roland Mendel 12.50 2499.25 6984.50
12 Henriette Pfalzheim 12.50 2310.00 6984.50
12 Hari Kumar 12.50 2290.40 6984.50
12 Roland Mendel 12.50 2216.25 6984.50
12 Peter Franken 12.50 1926.06 6984.50
12 Lúcia Carvalho 12.50 1913.85 6984.50
12 Palle Ibsen 12.50 1704.00 6984.50
12 Horst Kloss 12.50 1684.00 6984.50
12 Giovanni Rovelli 12.50 1650.00 6984.50
12 Hari Kumar 12.50 1632.15 6984.50
12 Philip Cramer 12.50 1585.00 6984.50
12 Thomas Hardy 12.50 1477.00 6984.50
12 Mario Pontes 12.50 1442.50 6984.50
12 Alexander Feuer 12.50 1335.00 6984.50
12 Paula Parente 12.50 1255.80 6984.50
12 Pirkko Koskitalo 12.50 1132.35 6984.50
12 Maria Larsson 12.50 875.00 6984.50
12 André Fonseca 12.50 850.00 6984.50
12 Horst Kloss 12.50 770.00 6984.50
12 Carlos González 12.50 720.00 6984.50
12 Paula Wilson 12.50 629.50 6984.50
12 Martine Rancé 12.50 616.00 6984.50
12 Mary Saveley 12.50 572.10 6984.50
12 Helen Bennett 12.50 446.60 6984.50
12 Sven Ottlieb 12.50 420.00 6984.50
12 Zbyszek Piestrzeniewicz 12.50 399.85 6984.50
12 Bernardo Batista 12.50 393.45 6984.50
12 Manuel Pereira 12.50 387.50 6984.50
12 Roland Mendel 12.50 344.00 6984.50
12 Mario Pontes 12.50 315.00 6984.50
12 André Fonseca 12.50 280.00 6984.50
12 Liu Wong 12.50 228.00 6984.50
12 Thomas Hardy 12.50 191.10 6984.50
12 Christina Berglund 12.50 96.50 6984.50
12 Pascale Cartrain 12.50 28.00 6984.50
12 Paolo Accorti 12.50 18.40 6984.50
12 Patricio Simpson 12.50 12.50 6984.50
Products
Pricing
Demos
Tutorials
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0