Using the SaleCo SQL compose a T-SQL query to display the customer code and customer last name
Question:
Using theSaleCo SQLcompose a T-SQL query to display the customer code and customer last name from the customer table where a record is returned from the invoice table where the customer code equals the invoice customer code. (hint: exists)
Using the SaleCo SQL database (linked above) compose a T-SQL query to display the customer code, customer last name, and customer phone for phone numbers beginning with the prefix 894.
Using the SaleCo SQL database (linked above) compose a T-SQL query to display the customer code, invoice number invoice date, and invoice subtotal from invoice conditioned on the invoice subtotal is greater than $100 and from only customer codes 10011 and 10012. (hint: in)
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last