This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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.
- Fall '08