Test Your Knowledge: Exercises

Exercise 20-1. Let’s start with a simple exercise. The Northwind database contains a table named Orders. Write a program to retrieve the order date and shipped date of all the records in the Orders table.

Exercise 20-2. We’ll try something slightly more complicated now. Write a program to display the name and ID of products with fewer than 10 units in stock.

Exercise 20-3. Now for an exercise that involves multiple tables. Write a program to display the first and last names of the employees in region 1.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset