Question: Write SQL queries to determine results for each of the following. 1. Select the CustomerName and OrderID for all customers who ordered 'Aniseed Syrup', sorted
Write SQL queries to determine results for each of the following.
1. Select the CustomerName and OrderID for all customers who ordered 'Aniseed Syrup', sorted in alphabetical order.
2. Select the ProductName, Quantity, Price, and ExtendedPrice (Quantity * Price) for orders 10344 and 10345.
3. Select the first and last names and current age of all employees having a birthday in September.
4. Select the OrderID, count of products ordered, and total order cost for orders 10344 and 10345.
5. Select the total number of orders and total cost of orders shipped by 'Speedy Express' in February 1997.
6. Insert a new shipper with ID 4, name 'On Time Delivery', and phone '(503) 555 0123'.
7. Update products to increase prices on all products by 1 ($1.00).
8. Update products to reduce prices on all products by 1 (-$1.00).
9. Update the new shipper's name from 'On Time Delivery' to 'On-Time Delivery'.
10. Delete the new shipper.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
