Problems for You to Solve
Below, we show you the request statement and the name of the solution query in the sample databases. If you want some practice, you can work out the SQL you need for each request and then check your answer with the query we saved in the samples. Don’t worry if your syntax doesn’t exactly match the syntax of the queries we saved—as long as your result is the same.
Sales Orders Database
| 1. | “Customer Liz Keyser wants to order again the products ordered on December 11, 2007. Use June 12, 2008, as the order date and June 15, 2008, as the shipped date.”
(Hint: You need to copy rows in both the Orders and Order_Details tables. Assume that you can add 1000 to the OrderID column value that you find for the December 11 order ... |
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
