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

Top 1000 Australian Internet customers for 2020

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Shen, Andres,20045596.960.000.000.00596.96
Stewart, Kaylee,24978155.080.000.000.00155.08
Prasad, Ruben,145012994.09699.100.000.002294.99
Rodriguez, Christian, R,2134614.980.000.000.0014.98
Shan, Kelsey,1290971.970.000.000.0071.97
Cooper, Jennifer, S,11187107.480.000.000.00107.48
Edwards, Courtney, A,276065997.333578.270.000.002419.06
Rogers, Sydney, C,276013578.273578.270.000.000.00
Williams, Kayla,2932438.980.000.000.0038.98
Hill, Lucas,276123578.273578.270.000.000.00
Bailey, Jesse, A,180614.990.000.000.004.99
Xu, Bonnie, C,145201503.58699.100.000.00804.48
Serrano, Carolyn, A,1722236.960.000.000.0036.96
Hughes, Alexandria, W,276255971.333578.270.000.002393.06
Chande, Dustin,18786119.980.000.000.00119.98
Phillips, Morgan,276175976.323578.270.000.002398.05
Baker, Jeremy,23471600.460.000.000.00600.46
Long, Kayla, W,276705976.323578.270.000.002398.05
Blanco, Nelson,23718567.760.000.000.00567.76
Ye, Warren,276143578.273578.270.000.000.00
Salah, Tamer, A,1263648.970.000.000.0048.97
Jai, Elijah,23443722.770.000.000.00722.77
Zheng, Bianca, G,276625997.333578.270.000.002419.06
Yuan, Donna, D,2943477.960.000.000.0077.96
Truempy, Marcel,145581528.07699.100.000.00828.97
Zhou, Brittney, K,2414811.940.000.000.0011.94
Russell, Jeremiah, L,29257165.280.000.000.00165.28
Taylor, Justin, G,280665997.333578.270.000.002419.06
Butler, Taylor,19718579.970.000.000.00579.97
Gomez, Philip,280385985.313578.270.000.002407.04
Simmons, Carson, A,19129639.450.000.000.00639.45
Wood, Amanda, S,280686021.823578.270.000.002443.55
Mitchell, Jack, L,280403578.273578.270.000.000.00
Powell, Riley, M,2235014.980.000.000.0014.98
Pal, Karla, A,258401249.840.000.000.001249.84
Turner, Gabrielle, A,280636026.313578.270.000.002448.04
Gonzalez, Jason,280305971.333578.270.000.002393.06
Price, Anna,145761476.54699.100.000.00777.44
Hughes, Abigail, T,19122588.960.000.000.00588.96
Brown, Joseph, M,280423578.273578.270.000.000.00
Ross, Melanie, H,258725819.053399.990.000.002419.06
Rogers, Katherine, B,203951179.970.000.000.001179.97
Ross, Samantha, R,279185998.613578.270.000.002420.34
Carter, Angel,276783578.273578.270.000.000.00
She, Alejandro, H,178734203.320.000.002443.351759.97
Navarro, Craig,153577232.370.002443.352419.062369.96
Nath, Tamara,280645962.343578.270.000.002384.07
Howard, Bryce, E,16108633.960.000.000.00633.96
Rogers, Natalie, A,145771505.86699.100.000.00806.76
Romero, Victor, C,122112329.980.000.000.002329.98
Wright, Rebecca, J,280413578.273578.270.000.000.00
Foster, Anna, A,11646113.480.000.000.00113.48
Harris, Rachel,167532319.990.000.000.002319.99
Carter, Carlos, A,258675784.063399.990.000.002384.07
James, Olivia,167552316.970.000.000.002316.97
Scott, Janet, L,292784355.610.003578.270.00777.34
Young, Logan,2739133.980.000.000.0033.98
Griffin, Faith, L,274074490.480.000.002071.422419.06
Alexander, Eric, S,281853578.273578.270.000.000.00
Cox, Alexa,2050564.970.000.000.0064.97
Hayes, Alexandria, C,2747460.470.000.000.0060.47
Coleman, Gabrielle,281643578.273578.270.000.000.00
Gomez, Deanna,156552753.820.002181.560.00572.26
Foster, Spencer, J,2161214.980.000.000.0014.98
Diaz, Kyle,145801468.59699.100.000.00769.49
Martin, Matthew, F,2626721.490.000.000.0021.49
Patterson, Katherine, E,281545971.333578.270.000.002393.06
Johnston, Julia,1583739.980.000.000.0039.98
Johnson, Isabella, P,281703578.273578.270.000.000.00
Martinez, Ronald, J,2351778.960.000.000.0078.96
Moreno, Nelson, R,1770432.270.000.000.0032.27
Torres, Riley, T,2053514.980.000.000.0014.98
Russell, Madison,281843578.273578.270.000.000.00
Long, Mya, O,281915997.333578.270.000.002419.06
James, Shelby, A,2011278.980.000.000.0078.98
Cook, Kimberly, R,281905997.333578.270.000.002419.06
Ye, Karen, L,254764.990.000.000.004.99
Howard, Jeremiah, L,146391547.570.00699.100.00848.47
Evans, Katherine, E,1615264.470.000.000.0064.47
Garcia, Lydia, P,281946114.813578.270.000.002536.54
Luo, Kelli,2394653.980.000.000.0053.98
Martin, Zachary, E,282575976.320.003578.270.002398.05
Mitchell, Madeline,282735962.340.003578.270.002384.07
Arun, Meredith, H,269631237.820.000.000.001237.82
Peterson, Isaiah,266172881.740.000.002071.42810.32
Davis, Samantha, P,282446026.310.003578.270.002448.04
Stewart, Faith,260585838.050.003399.990.002438.06
Zheng, Susan, K,2471968.970.000.000.0068.97
Mitchell, Samuel, C,282596118.610.003578.270.002540.34
Washington, Madison,200591170.480.000.000.001170.48
Rai, Marshall, A,259035773.040.003374.990.002398.05
Campbell, Jordan, T,282685997.330.003578.270.002419.06
Wang, Robert, B,1323621.980.000.000.0021.98
Edwards, Maria, G,282984828.110.003578.271249.840.00
Butler, Hailey, D,198651155.480.000.000.001155.48
Hill, Amber, W,145963056.050.00699.100.002356.95
Liu, Laura,199981155.480.000.000.001155.48
Clark, Eduardo,282405998.610.003578.270.002420.34
Shan, Alisha,122764416.380.000.002071.422344.96
He, Margaret,123089691.000.000.002500.447190.56
Shan, Jonathan,282993578.270.003578.270.000.00
Rana, Carmen, A,149408367.550.003578.272419.062370.22
Sharma, Katrina, M,116144438.060.000.002049.102388.96
James, Carlos,283553578.270.003578.270.000.00
Long, Samuel, A,282703578.270.003578.270.000.00
Wu, Jessie, L,2379232.600.000.000.0032.60
Cox, Shelby, V,282933578.270.003578.270.000.00
Sanders, Makayla,21761134.980.000.000.00134.98
Phillips, Jordan,2535149.480.000.000.0049.48
Srini, Marco, A,282886039.300.003578.270.002461.03
Wood, Xavier,2373274.450.000.000.0074.45
Rai, Nicolas, A,146013076.060.00699.100.002376.96
Dominguez, Desiree, S,114279917.990.003399.992354.984163.02
Anderson, Justin,286603578.270.003578.270.000.00
Williams, Devin, T,286674370.610.003578.27792.340.00
Russell, Gabrielle, J,286714320.620.003578.27742.350.00
Howard, Seth,287903578.270.003578.270.000.00
Cooper, Juan, D,287943578.270.003578.270.000.00
Rogers, Danielle,1451189.970.000.000.0089.97
Nath, Nina,1316285.480.000.000.0085.48
Collins, Edward, M,286273578.270.003578.270.000.00
Campbell, Robert,287613578.270.003578.270.000.00
Johnson, Blake,286724355.610.003578.27777.340.00
Hughes, Eric,287723578.270.003578.270.000.00
Rowe, Latasha, L,287743578.270.003578.270.000.00
Rubio, Diana,163106010.160.000.003693.192316.97
Clark, Jessica, L,286503578.270.003578.270.000.00
Bailey, Jasmine, E,286583578.270.003578.270.000.00
Gonzalez, Hunter, C,2520196.070.000.000.0096.07
Serrano, Naomi,259164649.830.003399.990.001249.84
Raji, Tonya,248042384.070.000.000.002384.07
Robinson, Hannah,259245819.050.003399.990.002419.06
Russell, Justin,16504588.960.000.000.00588.96
Cox, Sean, J,26086149.980.000.000.00149.98
Russell, Jordan, L,2442671.580.000.000.0071.58
Gray, Xavier,286433578.270.003578.270.000.00
Flores, Jocelyn,27198147.950.000.000.00147.95
Howard, Mason, D,2139749.970.000.000.0049.97
Anand, Donna, M,286654852.600.003578.270.001274.33
Bryant, Dylan, J,146141645.550.00699.100.00946.45
Alvarez, Lee, A,19890119.980.000.000.00119.98
Perez, Harold, C,289883578.270.003578.270.000.00
Bailey, Nicole, K,288424393.580.003578.27815.310.00
Wu, Autumn,225683.990.000.000.003.99
Hernandez, Caleb, A,288253578.270.003578.270.000.00
Sutton, Tara, A,25633110.460.000.000.00110.46
Wright, James, A,161182563.910.000.000.002563.91
Reed, Olivia, L,290583578.270.003578.270.000.00
Coleman, Riley, L,291393578.270.003578.270.000.00
Thomas, Andrew, C,290044320.620.003578.270.00742.35
Alexander, Brandon,15273103.480.000.000.00103.48
Hayes, Samantha,23377556.930.000.000.00556.93
Pal, Lindsay, E,1494336.960.000.000.0036.96
Xu, Carly, G,288474355.610.003578.270.00777.34
Ramirez, Taylor, D,290324389.590.003578.270.00811.32
Taylor, Richard,22789574.980.000.000.00574.98
Harrison, Valerie, H,288404399.100.003578.27820.830.00
Vance, Pedro, A,11499192.210.000.000.00192.21
Parker, Jason, F,259694649.830.003399.990.001249.84
Nelson, Caleb,22716553.970.000.000.00553.97
Long, Gabriel,290173578.270.003578.270.000.00
Holt, Claudia,165344820.500.000.002181.562638.94
Smith, Sydney, M,291103578.270.003578.270.000.00
Murphy, Garrett,288493578.270.003578.270.000.00
Mitchell, Miguel,288513578.270.003578.270.000.00
Lee, Katherine, A,2922638.980.000.000.0038.98
Phillips, Elijah,288353578.270.003578.270.000.00
Jackson, Ashley,2667468.970.000.000.0068.97
Sandberg, Abby,124945948.230.003578.270.002369.96
Price, Chloe,288433578.270.003578.270.000.00
Cai, Micah,288594355.610.003578.270.00777.34
Morris, Isaiah,290194355.610.003578.270.00777.34
Jenkins, Katherine, E,2236445.220.000.000.0045.22
Hernandez, Pedro,2190514.980.000.000.0014.98
Martinez, Kayla, E,2744431.280.000.000.0031.28
Gonzales, Brandon, D,288243578.270.003578.270.000.00
Yang, Brandon,243512393.060.000.000.002393.06
Cox, Trinity,22043588.960.000.000.00588.96
Green, Robert, L,1877169.990.000.000.0069.99
Sanders, Nathaniel, L,1461939.980.000.000.0039.98
Ma, Jake, G,1261739.470.000.000.0039.47
Price, Fernando,281274.990.000.000.004.99
Henderson, Noah, L,290896.280.000.000.006.28
Collins, Jeremy,130874803.330.002443.350.002359.98
Martinez, Alexander, K,2482734.890.000.000.0034.89
Young, Natalie, C,2336432.280.000.000.0032.28
Adams, Mary, D,129504760.320.002443.350.002316.97
Bryant, Stephanie, V,206349.990.000.000.009.99
Walker, Jonathan,1915278.980.000.000.0078.98
Davis, Jennifer, A,1638259.980.000.000.0059.98
Sanchez, Arianna,278091164.470.000.000.001164.47
Chandra, Brett, S,1273744.980.000.000.0044.98
Sanz, Janet, J,178984208.310.000.002443.351764.96
Rana, Brandy, A,157106316.500.000.002181.564134.94
Wilson, Lauren, A,1488786.950.000.000.0086.95
Lewis, Charles, M,2367729.990.000.000.0029.99
Rogers, Jacqueline, S,250152461.550.000.000.002461.55
Perez, Eric, A,248082407.040.000.000.002407.04
Hall, Julia, L,1807458.980.000.000.0058.98
Srini, Patricia,1402891.950.000.000.0091.95
Hayes, Jose, M,1551261.960.000.000.0061.96
Xu, Karla, M,115834381.390.000.002071.422309.97
Diaz, Alfredo, W,1798859.920.000.000.0059.92
Hall, Katherine,2595927.280.000.000.0027.28
Peterson, Olivia,11862209.230.000.000.00209.23
Morris, Devin,1587515.230.000.000.0015.23
Shan, Lindsey,1785286.950.000.000.0086.95
Zhou, Kristen, R,23632162.990.000.000.00162.99
Ross, Cassidy, W,159091380.250.000.00782.99597.26
Martin, Neil,240783.990.000.000.003.99
Martin, Diana,2785139.980.000.000.0039.98
Perry, Aidan, O,120845985.210.003578.270.002406.94
Tang, Jon, K,144403367.380.000.001000.442366.94
Brown, Jessica, L,116715970.230.003578.270.002391.96
Gill, Micheal,255931264.840.000.000.001264.84
Gray, Mason,22089553.970.000.000.00553.97
Bryant, Sydney, S,114129879.960.003374.992366.944138.03
James, Xavier, C,2859549.990.000.000.0049.99
Patterson, Aidan, B,2304437.270.000.000.0037.27
Madan, Ruben, M,21518144.450.000.000.00144.45
Romero, Jésus, R,1632624.990.000.000.0024.99
Jenkins, Ashley,2109113.980.000.000.0013.98
Lu, Barbara,1329321.980.000.000.0021.98
Rivera, Paige,169741729.970.000.000.001729.97
Ross, Angelica, A,22878553.970.000.000.00553.97
Fernandez, Tina,22722562.960.000.000.00562.96
Subram, Abby,132567494.880.000.002691.884803.00
Sanchez, Melissa,1188050.230.000.000.0050.23
Malhotra, Stefanie,149952832.030.000.002181.56650.47
Russell, Greg,24772195.590.000.000.00195.59
Lal, Christian, M,1348356.970.000.000.0056.97
Suarez, Philip, M,269741292.810.000.000.001292.81
Walker, Nathan,253831228.830.000.000.001228.83
Rana, Holly,197431194.970.000.000.001194.97
Williams, Robert, C,22873539.990.000.000.00539.99
Stewart, Brian,194261938.470.000.00782.991155.48
Hayes, Benjamin, C,22522539.990.000.000.00539.99
Adams, Kaylee, F,175481700.990.000.000.001700.99
Bennett, Abigail, L,283002.290.000.000.002.29
Deng, Alejandro,2451338.880.000.000.0038.88
Howard, Caitlin, A,2528338.880.000.000.0038.88
Alexander, Melissa,2482142.840.000.000.0042.84
Rodriguez, Alexander, S,2306429.990.000.000.0029.99
Scott, Robert, C,2043869.970.000.000.0069.97
Xie, Julie,21122143.780.000.000.00143.78
Carter, Jack,2146014.980.000.000.0014.98
He, Alvin,254907.280.000.000.007.28
Harris, Sydney, A,205272478.340.000.000.002478.34
Rodriguez, Jacob,143943344.700.000.001000.442344.26
Foster, Jasmine,2791439.980.000.000.0039.98

Generated 2025-11-01 01:31:30.826 UTC