Question: Make sure to make a copy of the TAL database and complete the following steps using the copy Create a separate query in the database

Make sure to make a copy of the TAL database and complete the following steps using the copy

Create a separate query in the database for each of the following exercises:

  • List the number and name of all customers that are represented by rep 15 and that have a credit limit of $10,00 (Save the query)
  • For each order, list the order number, order date, number of the customer that placed the order, and name of the customer that placed the order. (Save the query)
  • Find the total of the balances for all customers represented by rep 30. (Save the query)
  • Give the item number, description, and on-hand value (OnHand * Price) for each item in category GME. (Save the query)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!