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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started