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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Nelson, Sean,11841307.970.000.000.00307.97
White, Emma, N,16090604.960.000.000.00604.96
Murphy, Maria,160113657.260.000.000.003657.26
Chandra, Brandy, P,11501603.530.000.00128.21475.32
Garcia, Henry, B,112871009.240.000.00283.45725.79
Anderson, Madison, G,2835978.980.000.000.0078.98
Cox, Arianna, D,1892789.250.000.000.0089.25
Hill, Blake,11748131.540.000.000.00131.54
Chandra, Allen,2932753.990.000.000.0053.99
Nelson, Katherine,2802178.980.000.000.0078.98
Butler, Dalton, A,133454759.510.000.000.004759.51
Simmons, Haley, T,262022749.320.000.002181.56567.76
Griffin, Seth, R,17585164.460.000.0078.9885.48
Taylor, Taylor,159054899.020.000.000.004899.02
Nath, Carl, H,29001624.970.000.000.00624.97
Perry, Jackson, J,213064.990.000.000.004.99
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Williams, Ethan,243094793.120.003578.270.001214.85
Thompson, Abigail,243324816.090.003578.270.001237.82
Walker, Brandon, J,159164793.270.000.000.004793.27
Martin, Kellie, R,28195574.980.000.000.00574.98
Campbell, Chloe,11212760.930.000.00307.78453.15
Griffin, Jordan,13095328.890.000.0069.97258.92
Bell, Timothy, J,2810178.980.000.0078.980.00
Harris, Natalie,2368259.980.000.0059.980.00
Srini, Evelyn,16855150.950.000.000.00150.95
Cooper, Amanda, P,146064716.020.000.000.004716.02
Sanders, Sean,14341175.150.000.000.00175.15
Wilson, Chloe, A,11640409.120.000.00199.43209.69
Patterson, Taylor,12147271.450.000.000.00271.45
Powell, Jasmine, A,11505846.770.000.00441.44405.33
Bailey, Lauren,15864103.550.000.009.9993.56
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Brown, Anna,1624795.820.000.000.0095.82
Russell, Richard,2763322.260.000.000.0022.26
Cannata, Gabrielle, C,217254.990.000.000.004.99
Reed, Kaylee, R,17371151.920.000.000.00151.92
Jackson, Charles, P,112771305.660.000.00511.23794.43
Carter, Jason,11724210.090.000.00113.8696.23
Perez, Amber, D,13318214.260.000.00116.9197.35
Jones, Natalie, A,11845197.200.000.0082.26114.94
Peterson, Steven, L,234497.280.000.007.280.00
Simmons, Jennifer,112621010.560.000.00226.90783.66
Chen, Jack, E,17579151.430.000.000.00151.43
Rubio, Javier, E,1972664.240.000.0064.240.00
Diaz, Luke,12054402.530.000.00139.97262.56
Taylor, Lucas, V,115232376.960.000.002376.960.00
Campbell, Alex,119844730.320.000.004730.320.00
Gray, Sara,292472447.050.000.002447.050.00
Anderson, Destiny,12895336.650.000.0037.27299.38
Anderson, David, A,2209761.960.000.0061.960.00
Gray, Isabella,168203217.790.000.000.003217.79
Peterson, Julia, P,16497132.710.000.000.00132.71
Lewis, Zachary, L,14760167.260.000.000.00167.26
Flores, Emily,13206163.190.000.0069.9793.22
Rubio, Ruben, D,1887186.960.000.0086.960.00
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Washington, Alexandra, E,15498256.520.000.00223.9232.60
Reed, Paige,221126047.323578.270.002469.050.00
Miller, Victoria,15816188.020.000.00118.0569.97
Baker, Sean, T,247782858.490.002181.56676.930.00
Bennett, Antonio, C,11631707.500.000.00266.33441.17
Rogers, Andrea, L,14328308.660.000.00155.23153.43
Morris, Abigail, C,287762.290.000.000.002.29
Sandberg, Isaac,1335053.970.000.0039.9913.98
Green, Marcus, C,15974208.410.000.0091.95116.46
King, Morgan,196811179.970.000.000.001179.97
Ramirez, Abigail, S,1585974.140.000.0024.2749.87
Alexander, Aidan,17387148.190.000.00148.190.00
Diaz, Luis, D,11203801.770.000.00317.50484.27
Yang, Justin, S,153634719.040.000.000.004719.04
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Watson, Shelby, J,14911867.970.000.000.00867.97
Young, Julia, J,274144.990.000.000.004.99
Perry, Ana,112151155.520.000.00496.36659.16
Chapman, Nancy, E,11276840.150.000.00156.71683.44
Young, Sierra, J,11619634.840.000.00187.43447.41
Henderson, Gabrielle, B,186031205.470.000.001205.470.00
Washington, Christian, R,2668639.980.000.000.0039.98
Davis, James,11922275.500.000.0094.96180.54
Wright, Robert, C,158894848.030.000.000.004848.03
Green, Gabrielle, M,2181564.470.000.0064.470.00
Allen, Amanda,2235339.980.000.000.0039.98
Russell, Jacqueline,18391100.960.000.00100.960.00
Thompson, Ryan, M,113301111.360.000.00198.94912.42
James, Jeremiah, S,11661287.700.000.00104.97182.73
Murphy, Catherine, L,1650692.050.000.0030.9761.08
Cooper, Ariana,17348205.420.000.000.00205.42
Harris, Isabella,17119214.900.000.00214.900.00
Davis, Daniel,11711999.220.000.00100.46898.76
Smith, Katherine, J,13197105.190.000.0049.9755.22
Turner, Timothy, C,14641119.860.000.0049.9769.89
Cook, Bryce,2864069.990.000.000.0069.99
Patterson, Maria, G,1333094.950.000.0079.9714.98
Lal, Luke, L,11019698.230.000.00156.20542.03
Richardson, Melissa, E,111322371.940.000.002371.940.00
Edwards, Connor,16950211.010.000.0023.97187.04
Deng, Damien, A,16873578.460.000.000.00578.46
Walker, John, M,2858969.990.000.0069.990.00
Russell, Megan,16220562.960.000.000.00562.96
Garcia, Patricia,11651226.430.000.00134.9591.48
Thomas, Victoria, A,15536249.530.000.000.00249.53
Morgan, Timothy,14633242.500.000.0095.55146.95
Bailey, Hailey, R,262704.990.000.000.004.99
Moore, Matthew, W,13267109.950.000.0074.9834.97
Parker, Katherine,13268289.700.000.0068.97220.73
Torres, Mariah,16380195.950.000.000.00195.95
Prasad, Molly,243924329.610.003578.27751.340.00
Lopez, Carlos,186171147.770.000.001147.770.00
Cook, Megan, J,2029956.970.000.0056.970.00
Anderson, Emma, A,185801170.480.000.001170.480.00
Sanchez, Adrian, L,13179190.170.000.0077.92112.25
Gonzales, Luis,15856116.250.000.00116.250.00
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Lopez, Jack, I,2904751.460.000.000.0051.46
Smith, Tyler, J,2034156.970.000.000.0056.97
Hall, Luke, E,14745902.460.000.000.00902.46
Wright, Kyle,2371626.970.000.0026.970.00
Coleman, Isabel, S,12530337.900.000.00193.95143.95
Phillips, James, G,16846180.950.000.00180.950.00
Reed, Sean, L,145974803.310.000.000.004803.31
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Long, Brandon, M,16110650.470.000.000.00650.47
She, Kenneth,16096212.010.000.0080.96131.05
Ward, Ian,12056213.920.000.000.00213.92
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Thompson, Isabella,18756128.410.000.000.00128.41
Brown, Samantha, G,2514739.980.000.000.0039.98
James, Christina,17409219.920.000.000.00219.92
Campbell, Jordan,13290111.890.000.0074.9836.91
Scott, Kaitlyn, A,12159218.910.000.00203.9314.98
Gomez, Rebekah,13486225.440.000.0039.98185.46
Sharma, Jackson,16876151.840.000.0034.89116.95
Watson, Janet, S,2320859.980.000.000.0059.98
Carter, Sydney,12959203.920.000.000.00203.92
Carter, Madeline, A,2752269.990.000.000.0069.99
Bell, Alex, M,167543118.600.000.00756.332362.27
Flores, Arianna,217274132.243578.270.000.00553.97
James, Sara,198023374.993374.990.000.000.00
Green, Isabella,26620699.10699.100.000.000.00
Ye, Alisha, J,220084141.233578.270.000.00562.96
Martin, Lucas, L,221144183.233578.270.000.00604.96
Murphy, Emma,198445807.933374.990.000.002432.94
Martin, Xavier,222335997.330.003578.270.002419.06
Lewis, Seth,26782699.100.00699.100.000.00
Collins, Luis, J,227655978.610.003578.270.002400.34
Moore, Taylor, A,199874564.450.003374.990.001189.46
Turner, Courtney, A,229753578.270.003578.270.000.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Moore, Andrew, A,13944150.130.000.00107.8542.28
Parker, Morgan, S,1677236.960.000.0014.9821.98
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Parker, Blake,15008170.530.000.0074.9895.55
White, Abigail, T,15866145.820.000.0038.88106.94
Thomas, Emily,2180339.980.000.000.0039.98
Ramirez, Sydney,267007.280.000.007.280.00
Williams, Edward, D,14274121.560.000.009.99111.57
Hernandez, Haley, L,11769478.950.000.0078.98399.97
Scott, Haley,13701154.540.000.0036.59117.95
Johnson, Anthony, D,270224.990.000.004.990.00
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Hill, Jordan, J,16005198.730.000.00102.2796.46
Bryant, Gabriel,2765669.990.000.000.0069.99
Hughes, Jasmine,276284.990.000.000.004.99
White, Edward, J,15847205.460.000.000.00205.46
Li, Kevin, S,2518813.980.000.0013.980.00
Peterson, Jessica, M,11868247.010.000.0076.95170.06
Lee, Ethan, J,223597.280.000.007.280.00
Martinez, Jonathan,1330366.250.000.0042.2823.97
Martinez, Kristina, S,2134529.930.000.000.0029.93
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Bryant, Samantha,18345115.470.000.000.00115.47
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Turner, Amanda, L,203183241.900.002071.420.001170.48
Hall, Lauren, A,19648100.840.000.0036.5964.25
Flores, Brittany,169062359.980.000.000.002359.98
Kelly, Trinity,2609515.230.000.000.0015.23
Clark, Miguel, D,169872414.990.000.000.002414.99
Lewis, Brandon, A,2903769.990.000.0069.990.00
Diaz, Alyssa,139084715.330.000.002294.992420.34
Griffin, Jack, L,1768632.280.000.0032.280.00
Adams, Miguel,11659213.520.000.0064.97148.55
Liu, Arturo,13222150.410.000.0088.4461.97
Shan, Logan,1867760.960.000.0060.960.00
Griffin, Thomas, J,19015125.430.000.00125.430.00
Evans, Jesse,2191639.980.000.000.0039.98
Bryant, Nathan,2145059.980.000.000.0059.98
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Henderson, Ashley,111851381.370.000.00262.781118.59
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Sanders, Megan, A,15376136.240.000.0014.98121.26
Simmons, Jose,2464739.980.000.000.0039.98
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Phillips, Devin,18759112.060.000.000.00112.06
Morgan, Marcus, W,289682.290.000.000.002.29
Hall, Noah, A,1525175.250.000.0068.976.28
Simmons, Sarah, V,11500651.980.000.00155.22496.76
Powell, Spencer,14904468.120.000.000.00468.12
Gonzales, Miranda,11660324.720.000.0037.27287.45
Carter, Katherine,11861286.300.000.000.00286.30
Clark, Emily, R,120862294.990.000.000.002294.99
Rodriguez, Richard,12969180.790.000.000.00180.79
Sun, Arturo, C,11498557.540.000.00173.39384.15
Jenkins, Samantha,113311290.330.000.00542.74747.59
Jai, Jose,12944164.210.000.0039.99124.22
Watson, Marcus,2271585.480.000.000.0085.48
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Russell, Isabella, A,11507645.780.000.00181.91463.87
Taylor, Christian,2076456.760.000.000.0056.76
Griffin, Haley, L,1892582.180.000.000.0082.18
Hall, Elizabeth, L,13474339.480.000.0068.97270.51
Thomas, Logan, A,14091251.200.000.0053.99197.21
Taylor, Natalie, M,14338828.740.000.000.00828.74
Martin, John, A,144364776.010.000.000.004776.01
White, Cameron,238304802.110.003578.270.001223.84
Lopez, Katelyn,11820232.710.000.0092.74139.97
Diaz, Elijah,200004495.480.003374.990.001120.49
Patterson, Hailey, I,112231155.900.000.00465.56690.34
Hayes, Luis,12880200.730.000.000.00200.73
Washington, Hailey, S,2588559.980.000.000.0059.98
Murphy, Chase, J,2472958.980.000.000.0058.98
Kelly, Angel, E,15418232.230.000.0042.28189.95
Moore, Hunter,14897196.270.000.0071.58124.69
Robinson, Dylan, L,1472481.530.000.000.0081.53
Davis, Ethan,136604750.010.000.000.004750.01
Long, Kaitlyn,233964891.610.003578.270.001313.34
Reed, Isaac, D,260747.280.000.000.007.28
Price, Oscar, G,11833240.010.000.000.00240.01
Watson, Richard,15943365.410.000.00154.98210.43
Jones, Charles,22882101.450.000.000.00101.45
James, Maria,1624391.970.000.0069.9921.98
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Henderson, Hailey, C,171481775.470.000.000.001775.47
Griffin, Jason, L,112001267.110.000.00610.74656.37
Lal, Robert, L,14084138.680.000.0035.00103.68
Davis, Thomas,167641760.470.000.000.001760.47
Morgan, Jada, A,11520702.990.000.00300.89402.10
Young, Adam,12984200.200.000.00107.2692.94
Wilson, Nathan, L,13936218.930.000.000.00218.93
Jai, Samuel, L,1635887.950.000.0073.9713.98
Green, Mackenzie, C,280737.280.000.000.007.28
Collins, Xavier, C,16646250.910.000.000.00250.91
Sanders, Isaiah,2587339.980.000.000.0039.98
Flores, Devin, A,15559172.040.000.0086.5685.48

Generated 2024-09-19 21:36:15.336 UTC