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.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now