[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ 'GBP'  >   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
Alonso, Latasha, A,135918355.273578.270.000.004777.00
Prasad, Mayra,112387542.773399.990.003579.82562.96
Hughes, Kayla,14982152.450.000.00118.4733.98
Madan, Donald, R,2716867.490.000.000.0067.49
Sai, Gerald, L,27894548.980.000.000.00548.98
Navarro, Armando,199423034.07699.100.000.002334.97
Cox, Isaiah, E,135848361.293578.270.000.004783.02
Kapoor, Carolyn, M,1645947.260.000.007.2839.98
Sara, Andre, M,136615913.243578.270.000.002334.97
Rai, Dale, E,2173937.270.000.000.0037.27
Ramos, Teresa,136895898.263578.270.000.002319.99
Raman, Joe, G,1651147.260.000.0039.987.28
Alvarez, Robin, V,112437164.253399.990.003175.30588.96
Bailey, Ariana, J,136915976.743578.270.000.002398.47
Hu, Lisa, L,2111834.980.000.000.0034.98
Taylor, Charles,137927216.083578.270.000.003637.81
Brown, Nicole,113348154.023399.990.002334.972419.06
Zeng, Margaret, M,1619126.970.000.000.0026.97
Wright, Logan, M,137835955.233578.270.000.002376.96
Hu, Darryl,248682501.310.000.000.002501.31
Perez, Clifford, R,1569039.980.000.000.0039.98
Walker, Sydney, A,1904771.950.000.000.0071.95
Arun, Heidi, Z,201493165.42699.100.000.002466.32
Sharma, Wayne, E,1917524.990.000.000.0024.99
Xie, Sheena,1804132.270.000.000.0032.27
He, Lacey,144298394.290.003578.270.004816.02
Nath, Clayton,147935948.240.003578.270.002369.97
Mehta, Kristina, R,201653191.420.00699.100.002492.32
Patel, Emmanuel,144278451.260.003578.270.004872.99
Malhotra, Jay,141595930.230.003578.270.002351.96
Phillips, Nathan,2553738.980.000.000.0038.98
Raji, Nina, W,294802442.030.000.000.002442.03
Diaz, Krista,2891323.780.000.000.0023.78
Xu, Willie, J,141576650.600.003578.27777.342294.99
Munoz, Stacy,12310103.960.000.000.00103.96
Black, Raul,253011170.480.000.000.001170.48
He, Warren, L,171926977.580.000.002181.564796.02
Serrano, Frank,232321120.490.000.000.001120.49
Torres, Devin, A,237521164.470.000.000.001164.47
Lopez, Raymond, G,273176.280.000.000.006.28
Romero, Kristine, W,1630629.260.000.0021.987.28
Wang, Barbara, M,156525160.080.003578.270.001581.81
Dominguez, Naomi, B,147205900.550.003578.270.002322.28
Raman, Tammy,1212681.760.000.000.0081.76
Raji, Tracy,224391700.990.000.000.001700.99
Serrano, Jonathon, F,239541178.450.000.000.001178.45
Green, Morgan, M,2846960.470.000.000.0060.47
Anand, Karla,171856954.570.000.002181.564773.01
She, Karla, T,122156890.730.002071.420.004819.31
Navarro, Lawrence,2793992.970.000.000.0092.97
Gill, Randall, A,1816582.260.000.000.0082.26
Sandoval, Jill,1414390.580.000.000.0090.58
Perez, Fernando,2784827.770.000.000.0027.77
Navarro, Dwayne, H,116155205.710.002071.42777.342356.95
Jai, Grant,242001120.490.000.000.001120.49
Dominguez, Lori,126486817.600.000.002049.104768.50
Walker, Sarah, R,13814230.040.000.00122.96107.08
Subram, Allen,1789529.980.000.000.0029.98
Rivera, Seth,17879119.950.000.000.00119.95
Nath, Casey,116165253.650.002071.42784.282397.95
Raje, Yolanda,208522546.960.000.00782.991763.97
Long, Maria,1603661.960.000.000.0061.96
Gill, Marvin, M,178216.280.000.000.006.28
Shan, Cedric, H,237751155.480.000.000.001155.48
Patterson, Margaret, J,1350743.970.000.000.0043.97
Tang, Johnny,1511968.870.000.000.0068.87
Washington, Haley, F,239041198.970.000.000.001198.97
Suarez, Marie,2942960.470.000.000.0060.47
Cooper, Mariah, J,279012433.040.000.000.002433.04
Martin, Mallory, J,137947212.063578.270.000.003633.79
McDonald, Gilbert, G,17226109.970.000.000.00109.97
Schmidt, Derrick, R,226051750.980.000.000.001750.98
Liang, Marshall, J,254471164.470.000.000.001164.47
Pal, Michele,17814133.930.000.0029.98103.95
Zeng, Valerie,179772966.030.000.002181.56784.47
Rodriguez, Jay, M,28411134.950.000.00134.950.00
Carlson, Derrick, R,28436617.470.000.000.00617.47
Hernandez, Mason, C,2778247.970.000.0047.970.00
Goel, Kara,164653271.790.002443.350.00828.44
Andersen, Bethany,2532439.980.000.0039.980.00
Hernandez, Jonathon, F,156996969.570.002181.560.004788.01
Carlson, Arthur, P,113438221.990.003399.992379.972442.03
Xu, Eugene, A,14208117.430.000.0058.4758.96
Vance, Joe, L,2887712.980.000.0012.980.00
Rai, Cedric,2283829.990.000.000.0029.99
Torres, Lawrence,1567131.550.000.007.2824.27
Garcia, Ryan, J,156928392.300.003578.270.004814.03
Bailey, Xavier,123054940.390.000.004391.41548.98
Ward, Alex, I,14542115.250.000.000.00115.25
Suarez, Max, A,14809115.250.000.0078.9836.27
Raji, Franklin,114006967.780.003374.992318.961273.83
Davis, Ashley,26407126.280.000.00126.280.00
Xu, Jenny, K,122226909.100.002049.100.004860.00
Deng, Brad, D,200423150.40699.100.002451.300.00
Zheng, Leah, R,12627110.940.000.000.00110.94
Sai, Tabitha,25741567.760.000.00567.760.00
Cooper, Kimberly, J,224574.990.000.000.004.99
She, Carl, A,123176823.420.000.006823.420.00
Suri, Marco,1645447.260.000.0039.987.28
Serrano, Walter, G,122994977.360.000.004428.38548.98
Gomez, Jay,262324.990.000.000.004.99
Gill, Darren, M,1140834.470.000.0034.470.00
Zhao, Valerie, R,1349348.960.000.0033.9814.98
Torres, Victor,1803064.970.000.0064.970.00
Sara, Arthur, D,237531193.450.000.000.001193.45
Alvarez, Mallory, L,2112456.960.000.000.0056.96
Fernandez, Chelsea, J,199057.280.000.000.007.28
Ye, Micah, A,2095237.270.000.000.0037.27
Navarro, Erika, K,1147653.990.000.000.0053.99
Navarro, Randall, A,186203001.040.000.002181.56819.48
Sharma, Nicolas, D,135175666.380.000.002049.103617.28
Jones, David, D,208663157.970.000.00782.992374.98
Moreno, Paula, W,135545641.250.000.002071.423569.83
Torres, Adrienne, C,114828143.030.003374.992354.982413.06
Ramos, Kari, D,247021174.480.000.000.001174.48
Raji, Karla, V,159296944.580.002181.560.004763.02
Kumar, Carly, R,247121120.490.000.000.001120.49
Wu, Heather, M,1926182.970.000.000.0082.97
Tang, Carly, A,224701735.980.000.000.001735.98
Wu, Dawn, T,114936958.800.003399.992329.981228.83
Deng, Dustin, F,114227075.270.003399.992334.981340.30
Ramos, Diana, J,287332407.040.000.000.002407.04
Rubio, Victor, S,1619390.470.000.004.9985.48
Evans, Kyle,27890561.480.000.000.00561.48
Andersen, Christine, A,2794512.980.000.000.0012.98
Vance, Douglas,1638794.960.000.000.0094.96
Ma, Leah, H,14553147.950.000.0078.9868.97
Tang, Nichole, C,156305136.370.003578.27806.76751.34
Alonso, Larry, B,1358697.960.000.000.0097.96
Howard, Carlos,27891597.950.000.000.00597.95
Brooks, Savannah, R,245582487.330.000.000.002487.33
Wilson, Jacob, H,150786675.600.003578.270.003097.33
Wang, Tamara, L,1788159.980.000.000.0059.98
Carter, Miguel,1377670.570.000.0070.570.00
Goel, Louis,240551170.480.000.000.001170.48
Romero, Nelson,25728574.980.000.00574.980.00
Henderson, Julian, J,156918341.290.003578.270.004763.02
Beck, Cristina, J,122845625.250.000.003295.262329.99
Madan, Dominic, F,21847187.980.000.000.00187.98
Carlson, Erika,164443271.820.002443.35828.470.00
Bell, Sebastian, D,2778538.980.000.000.0038.98
Gill, Adrienne,14953202.460.000.00202.460.00
Davis, Zachary, L,1657997.950.000.000.0097.95
Scott, Kyle, D,11419231.750.000.00182.7848.97
Chen, Alejandro,149476658.580.003578.270.003080.31
Kim, Carmen,255021174.480.000.000.001174.48
Raman, Rebekah, E,2245412.940.000.000.0012.94
Chandra, Deanna,181416972.860.000.002181.564791.30
Malhotra, Raymond, T,132516844.420.000.002049.104795.32
Dominguez, Ruben,165733001.040.000.002181.56819.48
Zhu, Valerie, M,1359951.250.000.000.0051.25
Hernandez, Maria,149506709.590.003578.270.003131.32
Kelly, Olivia, L,123915121.430.000.002049.103072.33
Tang, Casey,150465943.250.003578.270.002364.98
Sharma, Katie,211062537.970.000.00782.991754.98
Raje, Julie, H,122146803.920.002049.100.004754.82
Kennedy, Kelsey, M,239841155.480.000.000.001155.48
Zheng, Lisa, R,138465933.253578.270.000.002354.98
Lopez, Bryant,242184.990.000.000.004.99
Wang, Lisa, J,1720574.980.000.000.0074.98
Navarro, Hector,239071120.490.000.000.001120.49
Lin, Marshall,168227176.380.000.002443.354733.03
Suarez, Albert, W,2095032.280.000.000.0032.28
Torres, Ian, V,172076979.560.000.002181.564798.00
Ma, Damien,1561279.970.000.000.0079.97
Black, Nichole,224221735.980.000.000.001735.98
Henderson, Alexandria, R,1155534.990.000.000.0034.99
Ms., Rockne, Carol Ann, F.,201643150.400.00699.100.002451.30
Morgan, Kimberly, A,287352420.340.000.000.002420.34
Suri, Joe,2102837.270.000.000.0037.27
Lu, Bianca,132526820.460.000.002071.424749.04
Rai, Cassie, R,14194168.930.000.0068.9799.96
Sara, Cory, A,211052533.970.000.00782.991750.98
Tang, Nicolas, S,122825111.440.000.002791.452319.99
Chapman, Bob, W,2113469.970.000.000.0069.97
Dominguez, Natasha,2376929.480.000.0029.480.00
Gill, Krista,1266477.960.000.000.0077.96
Wang, Franklin, S,2938627.770.000.0027.770.00
Ramos, Alberto,122396901.420.002071.420.004830.00
Carlson, Dana, H,1486332.280.000.0032.280.00
Johnsen, Rebekah, J,199194.990.000.000.004.99
Luo, Karla, V,1157434.990.000.0034.990.00
Nath, Sheena,2580039.980.000.000.0039.98
Torres, Deb,115505241.430.002049.103192.330.00
Zimmerman, Curtis, T,147026729.570.003578.27777.342373.96
Chander, Christine, L,1783934.970.000.000.0034.97
Martin, Jerome, D,201703177.440.00699.100.002478.34
Munoz, Daisy,150815900.550.003578.270.002322.28
Ramos, Anne, R,113518068.030.003374.992294.992398.05
Martinez, Dalton, M,2841323.780.000.000.0023.78
Raman, Meredith,113818161.020.003399.992341.972419.06
Zheng, Mandy,2472189.970.000.000.0089.97
Perez, Michele, K,137725928.253578.270.000.002349.98
Madan, Joel, C,1788764.970.000.000.0064.97
Becker, Louis, J,241931199.460.000.000.001199.46
Carlson, Craig, G,172186907.560.000.002181.564726.00
Sanchez, Christina, S,1454628.990.000.0028.990.00
Davis, Edward,2889621.490.000.0021.490.00
Vance, Gerald, M,2784160.470.000.0060.470.00
Smith, Ethan,1453072.860.000.0036.5936.27
Hernandez, Naomi,256866.280.000.006.280.00
Torres, Cheryl, T,25727539.990.000.00539.990.00
Ashe, Francisco, W,123356912.600.000.006912.600.00
Martinez, Molly, S,13603133.940.000.0083.9749.97
Raman, Martin,1770978.950.000.0048.9729.98
Deng, Nichole,199334.990.000.004.990.00
Sun, Claudia, J,145256665.580.003578.27777.342309.97
Zhu, Lisa, R,150596793.540.003578.270.003215.27
Zhao, Rafael,1341245.260.000.000.0045.26
Yang, Luke,2852660.470.000.000.0060.47
Lin, Lisa, A,179793001.020.000.002181.56819.46
Sai, Kaitlin, J,14529254.060.000.000.00254.06
Becker, Karla, M,1273064.900.000.000.0064.90
Thompson, Noah, L,14547192.950.000.000.00192.95
Sun, Vincent, F,165857192.390.000.002443.354749.04
Chandra, Marie, A,257752451.300.000.000.002451.30
Romero, Armando, A,1259668.970.000.000.0068.97
Reed, Cole,12603117.450.000.000.00117.45
Ruiz, Stacy,168237242.350.000.002443.354799.00
Shen, Casey, D,1250384.460.000.0025.4858.98
Xu, Michele, K,15353325.830.000.00130.56195.27
Malhotra, Roy, P,232201174.480.000.001174.480.00
Kapoor, George, L,1367668.870.000.0036.2732.60
Sanchez, Raymond,115487068.270.003374.992429.461263.82
Richardson, Angel,126406752.130.000.004359.072393.06
Sharma, Grant, R,2396629.480.000.0029.480.00
Gutierrez, Roberto,1135513.980.000.000.0013.98
Rana, Brett, L,2094337.270.000.000.0037.27
Perez, Frederick,160533752.380.002181.560.001570.82
Goel, Kathryn,1274044.980.000.000.0044.98
Wu, Rafael,127455199.720.000.002071.423128.30
Anand, Alejandro, R,2889960.470.000.000.0060.47
Zhang, Trisha,1815682.260.000.000.0082.26
Bryant, Ian,273191775.470.000.000.001775.47
Long, Kelly, G,2554538.980.000.000.0038.98
Gomez, Gerald,177432793.520.000.002181.56611.96
Raji, Tara,123855118.750.000.002071.423047.33
Srini, Stanley,1804229.980.000.000.0029.98
Bradley, Isabel,27783165.280.000.000.00165.28
Mr., Shridhar, Shish,25761562.960.000.000.00562.96
Gill, Clinton,26210553.970.000.000.00553.97
Schmidt, Marc,128085111.440.000.002049.103062.34
Raje, Brendan,162504511.540.002181.560.002329.98
Gonzalez, Cassandra,1796732.270.000.000.0032.27
Zhou, Alejandro, A,12304123.450.000.000.00123.45
Liang, Clayton, E,1495829.480.000.000.0029.48
Gray, Savannah, E,13694105.560.000.000.00105.56
Vance, Erick,287422428.050.000.000.002428.05
Sharma, Dylan,1906684.960.000.000.0084.96
Andersen, Damien, K,2940253.990.000.000.0053.99

Generated 2025-10-31 18:55:09.982 UTC