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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!