with a 25 % discount( with a heading of Sale). Display the sale price with two decimal places using the ROUND function. Sort by price from lowest to highest.
5. Write a query that displays the customer _ first _ name, customer _ last _ name, and customer _ city from the customers table. Use the LIKE operator to only display customers that reside in any zipcode beginning with 4.
6. Write a query that displays the order id and order date for any orders placed from March 1, 2014 through April 30, 2014. Do this WITHOUT using the BETWEEN clause. Format the date field as Month dd, yyyy and use a heading of ― Ordered ‖.
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