Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

c. What groups were least represented? Why do you think this is so?

Answered: 1 week ago

Question

7. Describe phases of multicultural identity development.

Answered: 1 week ago