CIS 336 iLab 4 Introduction to Select, Insert, Update, and Delete Sta CIS 336 iLab 4 Introduction to Select, Insert, Upd - Page 3

7. Write a query that displays the order id and order date for any orders placed during the month of May, 2014. Do this using the BETWEEN clause. Format the date field as mm/dd/yy and use a heading of “Ordered”. 8. Write a query which displays the order id, customer id, and the number of days between the order date and the ship date (use the DATEDIFF function). Name this column “Days” and sort by highest to lowest number of days. Only display orders where this result is 15 days or more. 9. Write a query which displays the order id, customer id and order date for all orders that have NOT been shipped, sorted by order date with the most recent order at the top. 10. The Marketing Department has requested a new report of shipped orders for which the order was placed on either a Saturday or a Sunday. Write a query which displays the order id, order date, shipped date, along with a calculated column labeled “Order_Day” showing the day of the week the order was placed (use the DAYNAME function). Only display orders that have shipped and were placed on a Saturday or Sunday. Sort by order date with most recent orders at the top. 11. Write a query to display the customer last name, phone number, and fax number but only display those customers that have a fax number. 12. Create a statement to insert a new record into the items table with the following values: item_id: 11 title: Ode To My ERD Artist_id: 15 unit_price: 12.95 Show your INSERT statement along with the results of the following SELECT query to verify that the insert worked correctly. select * from items where item_id> 10; 13. Create a statement to update the record inserted in the previous step to change the uni