[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ 'CAD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   <  ORDER BY 2020   <  SKIP 1250  >   <  TAKE 250  >   

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Nelson, Jennifer,171471700.990.000.000.001700.99
Griffin, Marcus,2075634.560.000.000.0034.56
Bryant, Gabriel,2765669.990.000.000.0069.99
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Hughes, Jasmine,276284.990.000.000.004.99
Patterson, Natalie,16123629.970.000.000.00629.97
Walker, Jasmine,134604693.040.000.002294.992398.05
Hughes, Anna,197052341.970.000.000.002341.97
Miller, Sydney, A,134404818.530.000.000.004818.53
Zhang, Nathan, L,2910478.980.000.000.0078.98
Ross, Elizabeth, E,141184741.340.000.002322.282419.06
Patterson, Abigail, H,144784795.010.000.000.004795.01
Li, Kevin, S,2518813.980.000.0013.980.00
Scott, Allison,14497804.480.000.000.00804.48
Long, Chloe,167841735.980.000.001735.980.00
Ashe, Alexis, S,194141145.480.000.000.001145.48
Hughes, Brittany,14387898.460.000.00898.460.00
Lewis, Morgan,17410168.740.000.000.00168.74
Martinez, Kristina, S,2134529.930.000.000.0029.93
Washington, Aaron, L,246494.990.000.000.004.99
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Jai, Luis, A,18320185.920.000.000.00185.92
Scott, Sean, F,2475539.980.000.000.0039.98
Flores, Hannah,1952540.230.000.000.0040.23
Jai, Kevin,1983678.960.000.0038.9839.98
Edwards, Madeline,2077146.470.000.000.0046.47
Jones, Joshua,184012294.990.000.000.002294.99
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Diaz, Thomas, O,16020595.960.000.00595.960.00
Wilson, Emily,174002331.950.000.000.002331.95
Campbell, Alex,119844730.320.000.004730.320.00
Jackson, Victoria,270194.990.000.000.004.99
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Stewart, Olivia, B,1874923.780.000.000.0023.78
Flores, Brittany,169062359.980.000.000.002359.98
Chen, Jonathan, G,13096200.690.000.000.00200.69
Kelly, Trinity,2609515.230.000.000.0015.23
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Lewis, Brandon, A,2903769.990.000.0069.990.00
Lee, Don,188392384.970.000.000.002384.97
Ramirez, Makayla, L,1750998.720.000.0037.2761.45
Gray, Cody, C,144594775.010.000.000.004775.01
Griffin, Jack, L,1768632.280.000.0032.280.00
Sanders, Zoe, L,248254.990.000.000.004.99
Alexander, Nathan, A,187951198.970.000.001198.970.00
Jones, Michael, A,2210771.970.000.000.0071.97
Alexander, Jason,2932849.990.000.000.0049.99
Cooper, Brian, L,13760128.840.000.000.00128.84
Price, Marissa,15826160.740.000.00120.4840.26
Gray, Seth, M,2008785.480.000.000.0085.48
Rivera, Rachel, S,2899678.980.000.000.0078.98
Wang, Karen, P,1955331.970.000.000.0031.97
White, Tyler,14291258.440.000.0049.97208.47
Jai, Hunter, M,28272111.950.000.000.00111.95
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Clark, Joseph, D,153954780.020.000.000.004780.02
Brooks, Ian, W,2829064.470.000.000.0064.47
Bell, Eduardo,27101782.990.000.00782.990.00
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Thomas, Isabella, M,27265782.990.000.00782.990.00
Bryant, Kyle,231644807.100.003578.271228.830.00
Cooper, Christina, C,265121000.440.000.001000.440.00
Harris, Megan,232814828.110.003578.271249.840.00
Thompson, Joshua, F,259992181.560.000.002181.560.00
Jackson, Joseph, R,235925279.260.003578.270.001700.99
White, Christopher, R,260492181.560.000.002181.560.00
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Coleman, Ashley,27297782.990.000.00782.990.00
Washington, Vanessa,238194802.110.003578.270.001223.84
Mitchell, Maria, D,27404782.990.000.00782.990.00
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Foster, Olivia,238063578.270.003578.270.000.00
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Thompson, Abigail,243324816.090.003578.270.001237.82
Chander, Wayne, S,243444329.610.003578.27751.340.00
Patterson, Alexis,213484392.020.000.002049.102342.92
Jones, Zachary, J,27285782.990.000.00782.990.00
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Sanders, Mason, G,2345939.980.000.000.0039.98
Powell, Ian,2608564.470.000.000.0064.47
Srini, Ruben,18078200.940.000.0071.97128.97
Parker, Eduardo, M,12939169.420.000.00110.2059.22
Long, Gavin,13762186.030.000.0036.59149.44
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Young, Jenna, W,163652490.180.000.000.002490.18
Raje, Mindy, A,16083561.970.000.000.00561.97
James, Emma,127812329.980.000.000.002329.98
Thomas, William, A,216142589.090.000.002049.10539.99
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Simmons, Anna, K,124512367.920.000.000.002367.92
Allen, Angel, G,15571101.850.000.0034.8966.96
Garcia, Xavier, M,2030071.970.000.000.0071.97
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Allen, Mason,176252431.950.000.000.002431.95
Russell, Nicole, M,182372318.960.000.000.002318.96
Simmons, Adam,253274.990.000.000.004.99
James, Morgan, E,2324539.980.000.000.0039.98
Thomas, Seth,14567161.280.000.0096.0765.21
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Stewart, Makayla,16649115.940.000.000.00115.94
Martinez, Carol, D,17656578.460.000.000.00578.46
Richardson, Charles, I,121144719.020.000.002325.962393.06
Foster, Paige,2742894.480.000.000.0094.48
Diaz, Gabrielle,14893839.480.000.000.00839.48
Foster, Emma,15468436.350.000.00159.99276.36
Davis, Jonathan,2925913.980.000.000.0013.98
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Lee, Kayla, M,2078115.230.000.000.0015.23
Flores, Cassidy, L,233684.990.000.000.004.99
Parker, Kaylee, M,2773878.980.000.000.0078.98
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Edwards, Alexandra,133582386.940.000.000.002386.94
Ramos, Derrick,18449100.940.000.0030.9769.97
Roberts, Jordan, M,1680039.250.000.000.0039.25
Jones, Samantha,1831721.980.000.000.0021.98
Adams, Jennifer,153624745.020.000.000.004745.02
Alexander, Sarah,1941129.990.000.000.0029.99
Andersen, Latoya, J,290578.990.000.000.008.99
Ward, Cole,214907.280.000.000.007.28
Alexander, Julia, J,15291889.470.000.000.00889.47
Collins, Amanda,2078339.980.000.000.0039.98
Anand, Brendan, L,1984721.980.000.000.0021.98
Ross, Kaitlyn,16121614.470.000.000.00614.47
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Bell, Julia,216522646.060.000.002646.060.00
Stewart, Melissa,2517336.960.000.000.0036.96
Johnson, Andrew, F,262942443.350.000.002443.350.00
Henderson, Olivia,188591155.480.000.000.001155.48
Parker, Jordan,216212616.860.000.002049.10567.76
Cooper, Amanda, P,146064716.020.000.000.004716.02
Moore, Fernando,265821000.440.000.001000.440.00
Powell, Caleb, G,216132610.580.000.002049.10561.48
Patterson, Grace, M,27560782.990.000.00782.990.00
Foster, Jose, C,2878534.990.000.000.0034.99
Garcia, Lucas,27545782.990.000.00782.990.00
Baker, Gabriella,174041709.980.000.000.001709.98
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Bryant, Dakota, L,176132401.950.000.000.002401.95
Bryant, Zachary,216552648.070.000.002648.070.00
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Jones, Natalie, A,11845197.200.000.0082.26114.94
Martin, Tyler, L,2772469.990.000.000.0069.99
Gray, Marcus, T,183892401.450.000.000.002401.45
Martin, Katherine, J,2027339.980.000.000.0039.98
Kumar, Elijah,15197156.920.000.000.00156.92
Richardson, Devin, G,2131836.960.000.000.0036.96
Murphy, Brianna, K,2834269.990.000.000.0069.99
Alexander, Angelica,2271471.950.000.000.0071.95
King, Sara,2235439.980.000.000.0039.98
Stewart, Alexandria,174761700.990.000.000.001700.99
Henderson, Austin,2764354.980.000.000.0054.98
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Jackson, Andrew,2047985.480.000.000.0085.48
Griffin, Miguel,2146476.970.000.000.0076.97
Johnson, Jacob, I,28069553.970.000.000.00553.97
Brooks, Mariah,216202620.400.000.002071.42548.98
Gonzalez, Jordan,15157213.940.000.00198.9614.98
Perry, Lauren,248164.990.000.000.004.99
Smith, Megan, J,2671668.970.000.000.0068.97
White, Judith, R,148851155.480.000.000.001155.48
Washington, Emma,191231170.480.000.000.001170.48
Sanders, Lucas, W,268024.990.000.000.004.99
Thompson, Madison, L,187882351.960.000.000.002351.96
Wood, Brittany,2877753.990.000.000.0053.99
Collins, Isaac,260777.280.000.000.007.28
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Russell, Jessica,265721000.440.000.001000.440.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
King, Jordan, C,110202316.970.000.002316.970.00
Washington, Riley, L,185441155.480.000.001155.480.00
Jackson, Edward,290422420.340.000.002420.340.00
Sanchez, Rachel, C,267304.990.000.000.004.99
Hall, Jason, A,29351119.980.000.000.00119.98
Thompson, Lucas, O,212774.990.000.000.004.99
Rogers, Olivia,12020804.470.000.000.00804.47
Lewis, Rachel, J,14900839.480.000.000.00839.48
Coleman, Samuel, N,17450123.980.000.000.00123.98
Russell, Caleb,23552103.480.000.000.00103.48
Edwards, Hailey,242584.990.000.000.004.99
Anderson, Madison, G,2835978.980.000.000.0078.98
Chandra, Allen,2932753.990.000.000.0053.99
Martinez, Dominique,287888.990.000.008.990.00
Diaz, Jason,17374206.630.000.0089.46117.17
Cannata, Gabrielle, C,217254.990.000.000.004.99
Gonzales, Jordan,2368113.980.000.000.0013.98
Phillips, Haley, B,2807939.980.000.000.0039.98
Thompson, Tyler,2750269.990.000.0069.990.00
Foster, Aaron,155664912.470.000.000.004912.47
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Lee, Samantha, B,2737878.980.000.000.0078.98
Allen, Luke,113162349.980.000.002349.980.00
Allen, Jack, M,291372419.060.000.002419.060.00
Nath, Alison, J,171161764.960.000.000.001764.96
Richardson, Lauren, C,14867839.480.000.000.00839.48
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Robinson, Ian, D,138522294.990.000.000.002294.99
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Thomas, Jessica,1684894.480.000.0094.480.00
Martin, Madison, C,2049271.970.000.0071.970.00
Morgan, Isabella, L,28602144.470.000.000.00144.47
James, Julia,2497567.930.000.000.0067.93
Price, Caroline,180511735.980.000.000.001735.98
Coleman, Miguel, D,2740069.990.000.0069.990.00
Wright, Jennifer,2650559.980.000.0059.980.00
Evans, Maria,22544127.280.000.00127.280.00
Collins, Jonathan,16849119.980.000.000.00119.98
Hall, Wyatt,2382713.980.000.000.0013.98
Griffin, Seth, R,17585164.460.000.0078.9885.48
Nath, Carl, H,29001624.970.000.000.00624.97
Bell, Chase,180911750.980.000.000.001750.98
Moore, Logan,2634889.970.000.0089.970.00
Hernandez, Jamie,27283119.980.000.00119.980.00
Chen, Luis, G,2125294.450.000.0094.450.00
Bell, Timothy, J,2810178.980.000.0078.980.00
Jones, Alexandra, B,2020245.950.000.000.0045.95
Gonzalez, Molly,1637021.980.000.000.0021.98
Sara, Ivan, L,2509067.930.000.000.0067.93
Roberts, Noah, S,2704268.490.000.000.0068.49
Morris, Jessica,289678.990.000.008.990.00
Reed, Michelle,2804669.990.000.000.0069.99
Patterson, Austin, O,270247.280.000.000.007.28
Ward, Eduardo, I,139162354.980.000.000.002354.98
Perry, James,192051249.840.000.000.001249.84
Richardson, Arianna, C,1205534.980.000.0034.980.00
Blanco, Armando, F,139182397.950.000.000.002397.95
Foster, Nicole, A,2349489.970.000.000.0089.97
Howard, Danielle,28357133.490.000.000.00133.49
Diaz, Brandon,236764.990.000.004.990.00
Evans, Jordan,2920939.980.000.0039.980.00
Bryant, Rachel,220197.280.000.007.280.00
Li, Jordan,17026261.390.000.00261.390.00
Adams, Kyle, E,1881269.990.000.0069.990.00
Ramirez, Richard, C,282397.280.000.007.280.00
Butler, Jackson, J,183241735.980.000.000.001735.98
Hughes, Austin, P,183681754.980.000.000.001754.98
Ward, Lucas, N,183631700.990.000.000.001700.99
Davis, Dylan,15556588.960.000.00588.960.00
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
Li, Brandon,2933973.960.000.000.0073.96
Williams, Destiny, S,15881564.990.000.00564.990.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Chen, David,2720839.980.000.000.0039.98
Russell, Katherine,2877169.990.000.000.0069.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Baker, Robert, A,273007.280.000.007.280.00
Ross, Aaron, N,118882376.960.000.002376.960.00

Generated 2024-09-20 05:25:16.398 UTC