Task:

List the orders for 2013 ranked by order amount within each month.

Click here for details on DENSE_RANK.

408 Records

Month	Customer	TotalAmount	Rank
1	Petersen Petersen	14000.00	1
1	Fresnière Fresnière	11493.20	2
1	Mendel Mendel	5796.00	3
1	Wilson Wilson	3868.60	4
1	Black Devon	3063.00	5
1	Mendel Mendel	2713.50	6
1	Lincoln Lincoln	2523.00	7
1	Holz Holz	2208.00	8
1	Roulet Roulet	2123.20	9
1	Carvalho Carvalho	2018.20	10
1	Parente Parente	1897.60	11
1	Kloss Kloss	1814.80	12
1	McKenna McKenna	1748.50	13
1	Rovelli Rovelli	1675.00	14
1	Rancé Rancé	1622.40	15
1	Batista Batista	1273.20	16
1	Lincoln Lincoln	1208.50	17
1	Pfalzheim Pfalzheim	1194.00	18
1	Fonseca Fonseca	1020.00	19
1	Mendel Mendel	1005.90	20
1	Lincoln Lincoln	802.00	21
1	Koskitalo Koskitalo	720.00	22
1	Pipps Pipps	651.00	23
1	Braunschweiger Braunschweiger	485.00	24
1	Roulet Roulet	480.00	25
1	Izquierdo Izquierdo	400.00	26
1	Koskitalo Koskitalo	372.00	27
1	Saavedra Saavedra	338.20	28
1	Moncada Moncada	319.20	29
1	Cruz Cruz	231.40	30
1	Moroni Moroni	192.00	31
1	Latimer Latimer	102.40	32
1	Accorti Accorti	49.80	33
2	Pavarotti Pavarotti	5793.10	1
2	Kloss Kloss	4277.40	2
2	Cartrain Cartrain	3891.00	3
2	Koskitalo Koskitalo	2684.00	4
2	Citeaux Citeaux	2210.80	5
2	Pavarotti Pavarotti	2096.00	6
2	González González	2051.60	7
2	Citeaux Citeaux	1838.20	8
2	Mendel Mendel	1792.00	9
2	Phillips Phillips	1755.00	10
2	Saveley Saveley	1688.00	11
2	Cramer Cramer	1584.00	12
2	Fresnière Fresnière	1078.00	13
2	Berglund Berglund	1031.70	14
2	Limeira Limeira	914.40	15
2	de Castro de Castro	851.20	16
2	Cramer Cramer	656.00	17
2	Black Brown	631.60	18
2	Josephs Josephs	567.50	19
2	Moroni Moroni	537.60	20
2	Saveley Saveley	531.40	21
2	jhon Hardy	453.00	22
2	Gutiérrez Gutiérrez	443.40	23
2	Roulet Roulet	414.00	24
2	Koskitalo Koskitalo	393.00	25
2	Larsson Larsson	360.00	26
2	Josephs Josephs	273.60	27
2	Larsson Larsson	234.80	28
2	Berglund Berglund	174.90	29
3	Wilson Wilson	10495.60	1
3	Hernández Hernández	3163.20	2
3	Ibsen Ibsen	2719.00	3
3	Rodriguez Rodriguez	1848.00	4
3	Lebihan Lebihan	1820.80	5
3	Cartrain Cartrain	1770.80	6
3	Izquierdo Izquierdo	1760.00	7
3	Franken Franken	1560.00	8
3	Limeira Limeira	1472.00	9
3	muter Ashworth	1328.00	10
3	Hernández Hernández	1272.00	11
3	Fernández Fernández	1249.10	12
3	Jablonski Jablonski	1125.50	13
3	Black Kumar	1051.20	14
3	Carvalho Carvalho	925.10	15
3	Rancé Rancé	756.00	16
3	Cramer Cramer	717.60	17
3	Cartrain Cartrain	713.30	18
3	Jablonski Jablonski	704.00	19
3	de Castro de Castro	672.00	20
3	Pipps Pipps	502.20	21
3	Saveley Saveley	496.00	22
3	muter Ashworth	386.20	23
3	Rodriguez Rodriguez	305.30	24
3	Rovelli Rovelli	235.20	25
3	Black Bennett	230.40	26
3	Afonso Afonso	216.00	27
3	Hernández Hernández	182.40	28
3	Black Brown	156.00	29
3	Steel Steel	147.00	30
4	Kloss Kloss	10588.50	1
4	Mendel Mendel	8623.45	2
4	Pavarotti Pavarotti	4735.44	3
4	Angel Paolino Angel Paolino	4150.05	4
4	Lebihan Lebihan	3000.00	5
4	Messner Messner	2657.80	6
4	McKenna McKenna	2614.50	7
4	Müller Müller	2427.50	8
4	Wang Wang	2356.00	9
4	McKenna McKenna	2048.50	10
4	González González	1412.00	11
4	Jablonski Jablonski	1388.50	12
4	Messner Messner	1380.60	13
4	Afonso Afonso	912.00	14
4	Lincoln Lincoln	896.00	15
4	kraków kraków	881.25	16
4	Fernández Fernández	816.30	17
4	Roulet Roulet	676.00	18
4	Cruz Cruz	618.00	19
4	Hernández Hernández	575.00	20
4	Roulet Roulet	550.80	21
4	Cramer Cramer	462.00	22
4	Black Crowther	352.00	23
4	Tannamuri Tannamuri	278.00	24
4	Pfalzheim Pfalzheim	240.00	25
4	Simpson Simpson	225.50	26
4	Domingues Domingues	200.00	27
4	Bergulfsen Bergulfsen	200.00	27
4	Moos Moos	149.00	28
4	Fresnière Fresnière	147.90	29
4	Moos Moos	136.80	30
5	Kloss Kloss	10191.70	1
5	Kloss Kloss	4181.50	2
5	Pipps Pipps	4180.00	3
5	Berglund Berglund	3192.65	4
5	Saveley Saveley	2812.00	5
5	Black Kumar	2715.90	6
5	Larsson Larsson	2295.20	7
5	Pontes Pontes	2162.80	8
5	kraków kraków	2156.50	9
5	Messner Messner	2085.00	10
5	Black Kumar	1908.00	11
5	Rodriguez Rodriguez	1836.00	12
5	Holz Holz	1823.80	13
5	Pfalzheim Pfalzheim	1819.50	14
5	González González	1770.00	15
5	Kloss Kloss	1670.00	16
5	Koskitalo Koskitalo	1546.30	17
5	Koskitalo Koskitalo	1344.00	18
5	Dewey Dewey	946.00	19
5	Hernández Hernández	880.50	20
5	Lebihan Lebihan	846.00	21
5	Black Devon	796.35	22
5	Pedro Freyre Pedro Freyre	749.00	23
5	Messner Messner	517.40	24
5	Cramer Cramer	493.80	25
5	Wilson Wilson	417.20	26
5	Snyder Snyder	396.20	27
5	muter Ashworth	355.50	28
5	Josephs Josephs	275.10	29
5	Steel Steel	210.00	30
5	muter Ashworth	139.80	31
5	Moncada Moncada	110.00	32
6	Pavarotti Pavarotti	3680.50	1
6	McKenna McKenna	3109.00	2
6	Larsson Larsson	2844.50	3
6	Fresnière Fresnière	2595.00	4
6	Koskitalo Koskitalo	2413.90	5
6	Feuer Feuer	2147.40	6
6	jhon Hardy	2142.90	7
6	kraków kraków	2082.00	8
6	Citeaux Citeaux	2040.00	9
6	Berglund Berglund	1565.65	10
6	Wilson Wilson	1299.00	11
6	Franken Franken	1257.30	12
6	Messner Messner	1152.50	13
6	Pfalzheim Pfalzheim	1067.10	14
6	Wilson Wilson	977.50	15
6	Limeira Limeira	965.00	16
6	Angel Paolino Angel Paolino	838.45	17
6	Petersen Petersen	835.20	18
6	Nagy Nagy	764.30	19
6	Fresnière Fresnière	711.00	20
6	Mendel Mendel	647.75	21
6	Citeaux Citeaux	625.00	22
6	Nagy Nagy	569.00	23
6	Citeaux Citeaux	547.80	24
6	Moroni Moroni	543.00	25
6	muter Ashworth	477.00	26
6	Cruz Cruz	387.50	27
6	Moos Moos	330.00	28
6	Yorres Yorres	317.75	29
6	Saavedra Saavedra	155.00	30
7	Pavarotti Pavarotti	6475.40	1
7	Pavarotti Pavarotti	6375.00	2
7	Mendel Mendel	6300.00	3
7	Snyder Snyder	5032.00	4
7	Fresnière Fresnière	4326.00	5
7	Kloss Kloss	3900.00	6
7	Messner Messner	2493.00	7
7	Wilson Wilson	2388.50	8
7	Hernández Hernández	2285.00	9
7	Snyder Snyder	1650.00	10
7	Pavarotti Pavarotti	1508.00	11
7	Jablonski Jablonski	1476.10	12
7	Domingues Domingues	1413.00	13
7	Fresnière Fresnière	1140.00	14
7	Josephs Josephs	1064.00	15
7	Ibsen Ibsen	812.50	16
7	Piestrzeniewicz Piestrzeniewicz	808.00	17
7	Batista Batista	807.38	18
7	Pipps Pipps	800.10	19
7	Phillips Phillips	565.50	20
7	Messner Messner	543.65	21
7	muter Ashworth	493.00	22
7	Latimer Latimer	479.80	23
7	Moos Moos	464.00	24
7	Labrune Labrune	424.00	25
7	Roulet Roulet	399.00	26
7	Hernández Hernández	358.00	27
7	Rodriguez Rodriguez	256.50	28
7	Parente Parente	142.50	29
7	Karttunen Karttunen	120.00	30
7	Snyder Snyder	72.00	31
7	Ibsen Ibsen	65.00	32
7	Moroni Moroni	28.00	33
8	Mendel Mendel	6483.05	1
8	Rancé Rancé	4985.50	2
8	Carvalho Carvalho	2896.25	3
8	Pedro Freyre Pedro Freyre	2775.05	4
8	Izquierdo Izquierdo	2720.05	5
8	Fresnière Fresnière	2697.50	6
8	Hernández Hernández	2054.00	7
8	McKenna McKenna	1928.00	8
8	Cruz Cruz	1820.20	9
8	Pontes Pontes	1535.00	10
8	Berglund Berglund	1503.60	11
8	Dewey Dewey	1434.00	12
8	Franken Franken	1429.75	13
8	Parente Parente	1422.00	14
8	Wong Wong	1393.24	15
8	Rovelli Rovelli	1380.25	16
8	Pavarotti Pavarotti	1264.50	17
8	Fresnière Fresnière	1260.00	18
8	clo'vis Mantri	1086.00	19
8	Müller Müller	945.00	20
8	Cramer Cramer	918.00	21
8	Petersen Petersen	870.00	22
8	Black Bennett	758.50	23
8	Batista Batista	636.00	24
8	Koskitalo Koskitalo	629.50	25
8	Müller Müller	620.00	26
8	Limeira Limeira	605.00	27
8	Bergulfsen Bergulfsen	500.00	28
8	clovis Trujillo	479.75	29
8	Citeaux Citeaux	450.00	30
8	Limeira Limeira	382.50	31
8	Roulet Roulet	62.00	32
8	Tannamuri Tannamuri	57.50	33
9	McKenna McKenna	6201.90	1
9	Pavarotti Pavarotti	5256.50	2
9	Kloss Kloss	4668.00	3
9	Holz Holz	4666.94	4
9	Pavarotti Pavarotti	4371.60	5
9	Berglund Berglund	4210.50	6
9	Franken Franken	2301.75	7
9	Lebihan Lebihan	2032.00	8
9	Mendel Mendel	1921.00	9
9	Pfalzheim Pfalzheim	1768.00	10
9	Latimer Latimer	1701.00	11
9	Phillips Phillips	1682.50	12
9	Pipps Pipps	1638.45	13
9	Rodriguez Rodriguez	1515.75	14
9	Franken Franken	1423.00	15
9	Snyder Snyder	1327.00	16
9	Wilson Wilson	1295.00	17
9	Carvalho Carvalho	1291.60	18
9	Franken Franken	1203.50	19
9	kraków kraków	956.90	20
9	Schmitt Schmitt	920.10	21
9	Fonseca Fonseca	801.10	22
9	McKenna McKenna	703.25	23
9	Müller Müller	694.75	24
9	Snyder Snyder	671.35	25
9	Berglund Berglund	668.70	26
9	Citeaux Citeaux	660.00	27
9	Petersen Petersen	570.00	28
9	Angel Paolino Angel Paolino	534.85	29
9	Müller Müller	530.40	30
9	Karttunen Karttunen	412.35	31
9	kraków kraków	375.50	32
9	Fonseca Fonseca	331.78	33
9	Moroni Moroni	193.00	34
9	Wilson Wilson	125.00	35
9	Labrune Labrune	63.00	36
9	Black Bennett	45.00	37
10	Kloss Kloss	10164.80	1
10	Kloss Kloss	4825.00	2
10	Pavarotti Pavarotti	4451.70	3
10	Mendel Mendel	3600.73	4
10	Ibsen Ibsen	3490.00	5
10	Cramer Cramer	3463.00	6
10	Fonseca Fonseca	3424.00	7
10	McKenna McKenna	3370.00	8
10	Pavarotti Pavarotti	2941.00	9
10	Pavarotti Pavarotti	2827.90	10
10	Larsson Larsson	2545.00	11
10	Jablonski Jablonski	2334.00	12
10	Pavarotti Pavarotti	2048.00	13
10	Phillips Phillips	1893.00	14
10	jhon Hardy	1704.00	15
10	Pavarotti Pavarotti	1570.00	16
10	Franken Franken	1331.75	17
10	Lebihan Lebihan	1296.00	18
10	McKenna McKenna	1238.40	19
10	Pontes Pontes	1150.00	20
10	Yorres Yorres	1125.67	21
10	Izquierdo Izquierdo	1073.90	22
10	Jablonski Jablonski	996.00	23
10	Kloss Kloss	972.50	24
10	clo'vis Mantri	878.00	25
10	Gutiérrez Gutiérrez	706.00	26
10	Karttunen Karttunen	642.00	27
10	Fresnière Fresnière	638.50	28
10	Berglund Berglund	630.00	29
10	Carvalho Carvalho	595.50	30
10	Batista Batista	550.00	31
10	Jablonski Jablonski	468.45	32
10	Hernández Hernández	378.00	33
10	clo'vis Mantri	330.00	34
10	Cruz Cruz	287.80	35
10	Nixon Nixon	180.40	36
10	Feuer Feuer	114.00	37
10	Accorti Accorti	93.50	38
11	Kloss Kloss	4529.80	1
11	Lincoln Lincoln	3118.00	2
11	Pavarotti Pavarotti	3082.00	3
11	Lebihan Lebihan	2598.00	4
11	Braunschweiger Braunschweiger	2487.50	5
11	Wang Wang	2311.70	6
11	Pavarotti Pavarotti	2196.00	7
11	Wang Wang	1990.00	8
11	Pipps Pipps	1912.85	9
11	Koskitalo Koskitalo	1871.25	10
11	Izquierdo Izquierdo	1850.00	11
11	Jablonski Jablonski	1770.00	12
11	Moroni Moroni	1710.00	13
11	Holz Holz	1701.46	14
11	Holz Holz	1644.60	15
11	Fonseca Fonseca	1498.35	16
11	Berglund Berglund	1459.00	17
11	Carvalho Carvalho	1296.75	18
11	Black Bennett	1080.00	19
11	McKenna McKenna	997.00	20
11	Ibsen Ibsen	920.00	21
11	Black Devon	655.00	22
11	Yorres Yorres	596.00	23
11	Lebihan Lebihan	509.75	24
11	Lebihan Lebihan	360.00	25
11	jhon Hardy	336.00	26
11	clovis Trujillo	320.00	27
11	jhon Hardy	285.00	28
11	Black Crowther	252.00	29
11	Henriot Henriot	240.00	30
11	Henriot Henriot	139.80	31
11	Accorti Accorti	88.00	32
11	Rovelli Rovelli	55.20	33
11	Perrier Perrier	52.35	34
12	Mendel Mendel	6984.50	1
12	Larsson Larsson	4337.00	2
12	Sommer Sommer	4035.80	3
12	Petersen Petersen	3923.75	4
12	Rancé Rancé	3687.00	5
12	Messner Messner	3603.22	6
12	Dewey Dewey	3304.00	7
12	Hernández Hernández	2878.08	8
12	Nixon Nixon	2775.00	9
12	Roulet Roulet	2760.80	10
12	Mendel Mendel	2540.00	11
12	Mendel Mendel	2499.25	12
12	Pfalzheim Pfalzheim	2310.00	13
12	Black Kumar	2290.40	14
12	Mendel Mendel	2216.25	15
12	Franken Franken	1926.06	16
12	Carvalho Carvalho	1913.85	17
12	Ibsen Ibsen	1704.00	18
12	Kloss Kloss	1684.00	19
12	Rovelli Rovelli	1650.00	20
12	Black Kumar	1632.15	21
12	Cramer Cramer	1585.00	22
12	jhon Hardy	1477.00	23
12	Pontes Pontes	1442.50	24
12	Feuer Feuer	1335.00	25
12	Parente Parente	1255.80	26
12	Koskitalo Koskitalo	1132.35	27
12	Larsson Larsson	875.00	28
12	Fonseca Fonseca	850.00	29
12	Kloss Kloss	770.00	30
12	González González	720.00	31
12	Wilson Wilson	629.50	32
12	Rancé Rancé	616.00	33
12	Saveley Saveley	572.10	34
12	Black Bennett	446.60	35
12	Ottlieb Ottlieb	420.00	36
12	Piestrzeniewicz Piestrzeniewicz	399.85	37
12	Batista Batista	393.45	38
12	Pereira Pereira	387.50	39
12	Mendel Mendel	344.00	40
12	Pontes Pontes	315.00	41
12	Fonseca Fonseca	280.00	42
12	Wong Wong	228.00	43
12	jhon Hardy	191.10	44
12	Berglund Berglund	96.50	45
12	Cartrain Cartrain	28.00	46
12	Accorti Accorti	18.40	47
12	Simpson Simpson	12.50	48

SQL Editor

Task: