MIS sql-2 - Brazil 114968.48 France 85498.76 Venezuela...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SELECT categories.CategoryID, CategoryName, count(productID) from Mis235.categories, mis235.products where categories.categoryID=products.categoryID group by categories.categoryName, categories.CategoryID order by count(productID) asc CATEGORYID CATEGORYNAME COUNT(PRODUCTID) 7 Produce 5 6 Meat/Poultry 6 5 Grains/Cereals 7 4 Dairy Products 10 2 Condiments 12 1 Beverages 12 8 Seafood 12 3 Confections 13 COUNTRY SUM(UNITPRICE*QUANTITY) USA 263566.98 Germany 244640.63 Austria 139496.63
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Brazil 114968.48 France 85498.76 Venezuela 60814.89 UK 60616.51 Sweden 59523.7 Ireland 57317.39 Canada 55334.1 SELECT customers.country, sum(unitprice*quantity) from mis235.orderdetails, mis235.customers, mis235.orders where customers.customerID=orders.CustomerID and orders.orderID=orderdetails.orderID group by customers.country having sum(unitprice*quantity) > 50000 order by sum(unitprice*quantity) desc...
View Full Document

This note was uploaded on 11/15/2011 for the course MIS 235 taught by Professor Sunrro during the Fall '08 term at Miami University.

Page1 / 2

MIS sql-2 - Brazil 114968.48 France 85498.76 Venezuela...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online