[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ 'CAD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   ORDER BY 2020 DESC  >   <  TAKE 250  >   TITLE Top 1000 Australian Internet customers for 2020   

Top 1000 Australian Internet customers for 2020

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Shan, Logan,1867760.960.000.0060.960.00
Sanders, Hailey,19647282.040.000.0086.45195.59
Perry, Benjamin,291652407.040.000.002407.040.00
Simmons, Jennifer,112621010.560.000.00694.54316.02
Martin, Samuel,15874225.440.000.00139.9685.48
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Hill, Haley, J,161033142.320.000.003142.320.00
Roberts, Mason, D,111761106.680.000.00800.00306.68
Edwards, Alexandra,133582386.940.000.000.002386.94
Diaz, Luis, D,11203801.770.000.00585.00216.77
Perry, Dalton, A,16149192.040.000.00122.0769.97
Edwards, Hunter,2422067.930.000.000.0067.93
Fernandez, Ruth,205463246.550.002049.100.001197.45
Alexander, Julia, J,15291889.470.000.000.00889.47
Anand, Brendan, L,1984721.980.000.000.0021.98
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Alexander, Caroline,176541759.970.000.000.001759.97
Long, Natalie,14363192.340.000.0014.98177.36
Hall, Lauren, A,19648100.840.000.00100.840.00
Powell, Jasmine, A,11505846.770.000.00688.58158.19
Thomas, Logan, A,14091251.200.000.00251.200.00
Roberts, Seth, H,11510258.150.000.0071.74186.41
Brooks, Ian, W,2829064.470.000.0064.470.00
Miller, Sydney, A,134404818.530.000.004818.530.00
Hayes, Luis,12880200.730.000.00165.7335.00
Richardson, Charles, I,121144719.020.000.004719.020.00
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Garcia, Patricia,11651226.430.000.00204.9421.49
Foster, Jessica,2606951.460.000.0051.460.00
Cooper, Ariana,17348205.420.000.00205.420.00
Harris, Matthew,14330806.760.000.00806.760.00
Jai, Jose,12944164.210.000.00164.210.00
Sanchez, Lucas, L,233514828.113578.270.001249.840.00
Bailey, Maria, C,1915034.980.000.000.0034.98
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Sharma, Jackson,16876151.840.000.0034.89116.95
Yuan, Carly,19839194.960.000.0069.97124.99
Bryant, Dakota, L,176132401.950.000.000.002401.95
Martin, Jill, C,11824181.030.000.00109.9671.07
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Foster, Carson, L,16959135.350.000.00135.350.00
Garcia, Isabella,18382204.940.000.00132.9771.97
Williams, Destiny, S,15881564.990.000.00564.990.00
Wilson, Chloe, A,11640409.120.000.00199.43209.69
Walker, Thomas,1307193.980.000.0063.9929.99
Green, Marcus, C,15974208.410.000.00138.4269.99
Peterson, Xavier, R,2645639.980.000.000.0039.98
Barnes, Kaitlyn, Z,15162154.960.000.009.99144.97
Wilson, Eduardo,15323804.470.000.000.00804.47
Smith, Chloe,17619163.920.000.0071.9791.95
Hall, Elizabeth, L,13474339.480.000.0083.95255.53
Bailey, Jessica, L,12945218.440.000.00218.440.00
Moore, Anthony, M,2473039.980.000.0039.980.00
Taylor, Natalie, M,14338828.740.000.00828.740.00
Price, Lauren, J,14079184.740.000.00115.7768.97
Coleman, Vanessa,215892589.090.000.002589.090.00
Zhang, Robert,188551155.480.000.001155.480.00
Davis, Ethan,136604750.010.000.004750.010.00
Smith, Lucas, P,1809064.910.000.0064.910.00
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Flores, Brandon, L,2562189.970.000.000.0089.97
White, Miguel, S,13988195.520.000.0074.98120.54
Thompson, Madison, L,187882351.960.000.000.002351.96
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Baker, Isaiah,12106169.540.000.00107.2862.26
James, Timothy,213312670.890.002071.42599.470.00
Perez, Eduardo, M,228956029.573578.270.002451.300.00
Perez, Dalton,110911125.360.000.00777.56347.80
Chapman, Nancy, E,11276840.150.000.00520.87319.28
Diaz, Jason,17374206.630.000.00206.630.00
Washington, Robert, J,14906143.950.000.0068.9774.98
Wright, Carol, C,12928247.410.000.00172.4374.98
Hall, Kaylee, E,1975137.270.000.0037.270.00
Jenkins, Alexandra, D,11632924.610.000.00822.36102.25
White, Tyler,14291258.440.000.00258.440.00
Brooks, Bryce,12061140.170.000.00125.1914.98
Russell, Melanie, B,15478182.830.000.00182.830.00
Martin, Madison, C,2049271.970.000.0071.970.00
Evans, Kaylee,19642133.540.000.0096.9536.59
Butler, Morgan, E,2050068.490.000.0068.490.00
Simmons, Dakota, T,14110819.460.000.00819.460.00
Ross, Alexia, S,13231247.900.000.00119.95127.95
Foster, Trevor, J,2896469.990.000.0069.990.00
Cooper, Paige,14119148.940.000.0073.9674.98
Ross, Antonio,18322148.890.000.00118.4130.48
Navarro, Jerome, B,11519717.280.000.00653.3163.97
Jackson, Charles, P,112771305.660.000.001068.67236.99
Sanders, Isaiah,2587339.980.000.000.0039.98
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Gonzalez, Jordan,15157213.940.000.00198.9614.98
Taylor, Brianna,17027230.900.000.00230.900.00
Hill, Alexandra, K,15172215.450.000.00145.4869.97
Morgan, Andrea, M,16870149.040.000.00149.040.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Rodriguez, Nicholas, D,14604137.950.000.00137.950.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Kennedy, Bridget,2202639.980.000.0039.980.00
Allen, Allison, A,1975737.270.000.0037.270.00
Flores, Kevin,15878225.920.000.00146.9478.98
Gonzalez, Jackson, S,14480194.940.000.00124.9569.99
Bailey, Alexandria, V,132092319.990.000.002319.990.00
Blue, Paige,2170313.980.000.0013.980.00
Martin, Jeremiah, E,173451764.960.000.001764.960.00
Griffin, Marcus,2075634.560.000.0027.287.28
Bell, Alexandria, A,13758284.130.000.00255.1428.99
Ross, Xavier, A,12202171.470.000.0099.5371.94
Alexander, Jordan,2141259.980.000.0059.980.00
Ross, Jose,2744178.980.000.0078.980.00
Torres, Taylor,16666205.440.000.00205.440.00
Patterson, Natalie,16123629.970.000.000.00629.97
Price, Isabelle,201825749.970.003374.990.002374.98
Morgan, Juan, C,1882191.970.000.0021.9869.99
Zhang, Nathan, L,2910478.980.000.000.0078.98
Yang, Aaron, C,2519654.980.000.000.0054.98
Liu, Arturo,13222150.410.000.0088.4461.97
Alexander, Lauren,189502351.960.000.000.002351.96
Stewart, Katherine, Z,229015971.333578.270.000.002393.06
Cooper, Timothy, J,206513198.570.002049.100.001149.47
Hill, Carlos,12919257.880.000.00158.9398.95
Wilson, Grace,17539205.920.000.0061.45144.47
Hernandez, Jamie,27283119.980.000.00119.980.00
Bell, Timothy, J,2810178.980.000.0078.980.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Green, Blake, P,11719287.200.000.00259.9227.28
Cooper, Grace, C,1601294.260.000.0094.260.00
Lal, Luke, L,11019698.230.000.00369.75328.48
Harris, Isabella,17119214.900.000.00214.900.00
Smith, Alexandra,2829261.960.000.0061.960.00
Turner, Kaylee, M,16213154.540.000.0082.5771.97
Ross, Seth, M,184332329.980.000.000.002329.98
Gonzales, Nathan, M,12107222.230.000.00222.230.00
Price, Jeremy,259892744.520.002181.56562.960.00
Robinson, Emily,12183228.420.000.00228.420.00
Scott, Allison,14497804.480.000.00804.480.00
Hughes, Nathan, B,121134737.530.000.004737.530.00
Ashe, Alexis, S,194141145.480.000.001145.480.00
Morgan, Jada, A,11520702.990.000.00553.75149.24
Jenkins, Samantha,113311290.330.000.00923.85366.48
Gonzales, Trevor, K,16085143.530.000.00143.530.00
Russell, Chloe, M,12763589.960.000.00589.960.00
Hall, Wyatt,2382713.980.000.000.0013.98
Ross, Rachel, C,206693169.590.002049.100.001120.49
Ramirez, Gabrielle, H,160004813.950.000.002394.892419.06
Lopez, Katelyn,11820232.710.000.00197.7334.98
Thomas, Seth,14567161.280.000.00146.3014.98
Thomas, Dalton,230097.280.000.000.007.28
Davis, Nicholas,1320173.160.000.0012.9460.22
Lewis, Christopher,1875586.960.000.0086.960.00
Chandra, Brandy, P,11501603.530.000.00300.14303.39
Gray, Jared, A,264494.990.000.004.990.00
Coleman, Logan,1868691.950.000.0091.950.00
Sanchez, Katherine, S,24399132.940.000.00132.940.00
Gonzalez, Amber, L,2387964.470.000.0064.470.00
Garcia, Henry, B,112871009.240.000.00726.61282.63
Washington, Aaron, L,246494.990.000.004.990.00
Perry, Justin, E,167583062.340.000.003062.340.00
Davis, Marcus, T,17337123.910.000.00101.9321.98
Lewis, Zachary, L,14760167.260.000.0047.28119.98
Bailey, Olivia,238924.990.000.004.990.00
Martin, Gina, E,11078793.270.000.00648.83144.44
Thomas, Matthew, K,13239185.700.000.0099.4786.23
Simmons, Sarah, V,11500651.980.000.00397.65254.33
James, Jeremiah, S,11661287.700.000.00137.24150.46
Collins, Hailey,11709325.890.000.00156.45169.44
Lee, Samantha, B,2737878.980.000.000.0078.98
Jenkins, Megan, R,12074261.380.000.0077.96183.42
Sharma, Thomas, A,18637121.940.000.0091.9529.99
Richardson, Erin, R,1633188.850.000.0088.850.00
Jones, Kayla, C,1854194.260.000.0069.9924.27
Flores, Megan, N,230746021.823578.270.000.002443.55
Lal, Jack, R,185251735.980.000.000.001735.98
Foster, Aaron,155664912.470.000.002430.442482.03
Coleman, Isabel, S,12530337.900.000.00262.9274.98
Chen, Jack, E,17579151.430.000.000.00151.43
Turner, Timothy, C,14641119.860.000.0084.8635.00
Srini, Evelyn,16855150.950.000.000.00150.95
Patterson, Taylor,12147271.450.000.0063.95207.50
Gonzalez, Morgan,130651700.990.000.001700.990.00
Hayes, Arianna,259912845.520.002181.56663.960.00
Peterson, Jared,11502829.370.000.00613.28216.09
Suri, Carolyn, S,12972175.710.000.00138.4437.27
Carter, Katherine,11861286.300.000.00101.26185.04
Ye, Alisha, J,220084141.233578.270.000.00562.96
Washington, Caroline, D,231145996.323578.270.000.002418.05
Hughes, Riley,2928449.990.000.000.0049.99
Roberts, Noah, S,2704268.490.000.000.0068.49
Bradley, Rachel,158504813.040.000.002374.982438.06
Coleman, Benjamin, F,234865343.230.003578.271764.960.00
Hughes, Luis,130841798.960.000.001798.960.00
Coleman, Luke, A,11723152.550.000.00152.550.00
Young, Kaylee, S,13756298.490.000.00298.490.00
Brown, Nicholas, S,11506675.640.000.00592.7182.93
Cox, Katelyn, B,2174230.970.000.0030.970.00
Stewart, Hailey,229036054.223578.270.002475.950.00
Hall, Amber,20106131.950.000.00131.950.00
Powell, Angela, R,12970471.110.000.00198.92272.19
Edwards, Connor,16950211.010.000.00211.010.00
Rivera, Ariana,261734.990.000.004.990.00
Martin, Brandon, S,2169139.980.000.0039.980.00
Sandberg, Chase,2190475.970.000.0075.970.00
Bell, Danielle,140414765.020.000.004765.020.00
Perry, Ana,112151155.520.000.00999.25156.27
Ross, Natalie, J,12916261.220.000.00188.9572.27
Roberts, Robert, R,1898656.970.000.0056.970.00
Torres, Pedro, E,16958168.020.000.00168.020.00
Lopez, Bailey, R,185571179.470.000.001179.470.00
Brooks, Steven, C,14877889.470.000.00889.470.00
Flores, Miguel,1975077.250.000.0039.9837.27
Sanchez, Nicole, L,14874804.480.000.00804.480.00
Sanders, Sean,14341175.150.000.00151.1823.97
Roberts, Amanda,171752334.980.000.002334.980.00
Wu, Randy, J,116472365.940.000.002365.940.00
Gray, Sara,292472447.050.000.002447.050.00
Anderson, Destiny,12895336.650.000.00123.21213.44
Price, Marissa,15826160.740.000.00154.466.28
Russell, Isabella, A,11507645.780.000.00418.06227.72
Hughes, Destiny, P,28027119.980.000.000.00119.98
Stewart, Sara,17347119.720.000.0021.9897.74
Long, Jordyn,1733847.250.000.0014.9832.27
Ross, Elizabeth, E,141184741.340.000.002322.282419.06
Washington, Alexandra, E,15498256.520.000.00223.9232.60
Baker, Sara, M,11827512.470.000.00255.73256.74
Sanchez, Stephanie,1786756.970.000.0056.970.00
Wilson, Emily,174002331.950.000.002331.950.00
Turner, Morgan,11823178.470.000.00141.8836.59
Smith, Katherine, J,13197105.190.000.0054.9650.23
Perry, Brandon,22095141.980.000.000.00141.98
Fernandez, Cesar,200355694.980.003374.990.002319.99
Lee, Don,188392384.970.000.000.002384.97
Smith, Noah,13175166.920.000.0039.98126.94
Moore, Seth,138512331.950.000.000.002331.95
Lee, James, J,2881769.990.000.0069.990.00
Baker, Sean, T,247782858.490.002181.56676.930.00
Powell, Jonathan,238584712.740.003578.271134.470.00
Ward, Devin, J,15378170.910.000.00146.9423.97
Adams, Connor,214232888.560.000.002049.10839.46
Adams, Miguel,11659213.520.000.0064.97148.55
Anderson, Ryan, W,132712319.990.000.000.002319.99
Young, Courtney,176222374.980.000.000.002374.98
Cox, Devin, C,134184768.050.000.004768.050.00
Lewis, Ryan, A,203124.990.000.004.990.00
Taylor, Edward, C,17442319.880.000.00230.9088.98
Nelson, Jose,19217185.020.000.00124.5560.47
Sanchez, Mariah, R,1922066.650.000.0066.650.00
Diaz, Brandon,236764.990.000.004.990.00
Ross, Anna, D,15494275.440.000.00149.97125.47
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Lee, Kayla, M,2078115.230.000.000.0015.23
Rogers, Bryce,174022304.980.000.000.002304.98
Parker, Kaylee, M,2773878.980.000.000.0078.98

Generated 2024-05-17 02:46:25.114 UTC