The Relational Model: SQL

In the following exercises use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2 (attached).

1. Write a select statement that shows all from the table Item.
2. Select all records from the table ORDERS where the Customernum is 126.
3. Write a SELECT statement to list the CustomerName of the table CUSTOMER for all CustomerNames that start with C.
4. Write a SELECT statement to list the description of items with a price below 30.
5. Find the order number and order date for every order for parts that have a price of more than 100.
6. Find the customer name and postal code for every customer whose rep is Tian (LastName).
7. Same as # 6 but use nested queries.

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.