Problem:

List customers in the US and their order counts and order amounts for 2013.
Click here for details on WITH CTE.
 
 13 Records
FirstName LastName OrderCount OrderAmount
Art Braunschweiger 2 2972.50
Karl Jablonski 8 10262.55
Yoshi Latimer 3 2283.20
Helvetius Nagy 2 1333.30
Liz Nixon 2 2955.40
Jose Pavarotti 17 60672.64
Rene Phillips 4 5896.00
Howard Snyder 6 9148.55
John Steel 2 357.00
Fran Wilson 3 1837.20
Paula Wilson 6 19658.70
Liu Wong 2 1621.24
Jaime Yorres 3 2039.42
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0