ISDD+SQL

media type="custom" key="29524455"


 * Questions**

Write down the SQL to be used on the Orders table to answer the questions below



1. Select a list of all items purchased for customerid 5888. Display the Customer_ID, Item, and Price for this customer. 2. Select all columns from the Order table for anyone who purchased a Tent. 3. Select the Customer_ID, Order_Date, and Item where items start with the letter "S". 4. Add a record (with the data of your choice) to the table 5. Update the order placed by Customer_ID 1992 for a parachute - the quantity should be 2 6. Sort the table in ascending order by Customer_ID 7. Sort the table in descending order by Price 8. Select the Customer_ID, Order_Date and Item for any Customer_IDs beginning with 19 9. Delete any entries relating to Customer_ID 3119


 * Practical Task**

Complete the booklet below: (Make sure to save the database first before opening it. )




 * You will need the following database to complete this task:**




 * Extension Activity**

[|Khan Academy Hour of Code SQL]

Test you SQL at []