Dofactory.com
SQL Editor

SQL Having Avg Example

Tables and Columns 

Task:

List all customer with average orders between $1000 and $1200.
Click here for details on Having.
 
 10 Records
FirstName LastName Average Order
Miguel Angel Paolino 1081.22
Isabel de Castro 1063.42
Alexander Feuer 1008.44
Thomas Hardy 1062.04
Pirkko Koskitalo 1107.81
Janete Limeira 1174.95
Antonio Moreno 1073.62
Rita Müller 1065.39
José Pedro Freyre 1183.01
Carine Schmitt 1057.39
Pricing
Jobs
Companies
Products
Demos
Learning
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.