{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right 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

{[ snackBarMessage ]}