group1_project3_day2sql

group1_project3_day2sql - MIS 235 Section N Project 3...

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

View Full Document Right Arrow Icon
MIS 235 11/3/09 Katie Hirvela Section N Nicholas Connolly Project 3 Tara Hyland Nicholas Lombardi Lindsey DiLibero 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 1. 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 COUNTRY SUM(UNITPRICE*QUANTITY) USA 263566.98 Germany 244640.63 Austria 139496.63 Brazil 114968.48 France 85498.76 Venezuela 60814.89 UK 60616.51 Sweden 59523.7 Ireland 57317.39 Canada 55334.1
Background image of page 1

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

View Full DocumentRight Arrow Icon
MIS 235 11/3/09 Katie Hirvela Section N Nicholas Connolly Project 3 Tara Hyland Nicholas Lombardi Lindsey DiLibero 2. SELECT customers.country, sum(unitprice*quantity) from mis235.orderdetails, mis235.customers, mis235.orders where customers.customerID=orders.CustomerID and orders.orderID=orderdetails.orderID
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the 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 / 3

group1_project3_day2sql - MIS 235 Section N Project 3...

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

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