Problem:

List all products with prices between $1 and $10.
Group the list into four equal parts (i.e. quartiles).
Click here for details on NTILE.
 
 14 Records
ProductName UnitPrice Quartile
Geitost 2.50 1
Guaraná Fantástica 4.50 1
Konbu 6.00 1
Filo Mix 7.00 1
Tourtière 7.45 2
Rhönbräu Klosterbier 7.75 2
Tunnbröd 9.00 2
Teatime Chocolate Biscuits 9.20 2
Rogede sild 9.50 3
Zaanse koeken 9.50 3
Jack's New England Clam Chowder 9.65 3
Sir Rodney's Scones 10.00 4
Aniseed Syrup 10.00 4
Longlife Tofu 10.00 4
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