Using data from the TAL Distributors database, define a view named TopLevelCust. It consists of the number,

Question:

Using data from the TAL Distributors database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are greater than or equal to $10,000.
a. Using SQL, write the view definition for TopLevelCust.
b. Write an SQL query to retrieve the number and name of all customers as well as the difference between their credit limit and balance in the TopLevelCust view.
c. Convert the query you wrote in Question 2b to the query that the DBMS will actually execute.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts of Database Management

ISBN: 978-1285427102

8th edition

Authors: Philip J. Pratt, Mary Z. Last

Question Posted: