CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 97

1. Write a query to determine the total number of items on each order.
Display the order_id and the total with a heading of TotalItems (note no
spaces). Filter to only display information for order_id of 600 or higher.
2. Re-do query 1 but filter to only show those orders with more than 2
items ordered. Sort by the number of items ordered, lowest to highest.
3. The order_details table has a quantity for each item ordered. Show
the total amount charged for each item on the order (quantity times
price). Display order_id, the item id, the unit price, the quantity times
price of the item labeled as “Itemtotal” (note NO spaces). Sort by order
id and filter to only display those order ids between 400 and 700.
4. Write a query to display the total amount for each order: show the
order id and total. Sort by descending order on the total and only
display orders with a total of $40 or more.
5. Re-do query 4 but show the customer name for each order (formatted
as a si ngle field with heading of Customer) along with the city, order id
and total. Filter to only display customers that live in California. Sort by
city.
6. Display the total amount of sales per item. Show title, total quantity
sold with a heading of Quantity, total sales with a heading of
“TotalSales” (not NO space). Sort by highest to lowest total.
7. Display the total sales for each customer: show customer name (as
single field) with a heading of Cutomer and total. Sort lowest to highest
total. Filter to only display customers with $50 or more in total orders.
8. Use subqueries to determine which (artist) had the item ordered in
highest quantity on an order? First determine the highest quantity on
any order, then determine the item number associated with it, then
display the artist.