-SQL-Database-management-assignment-help-

Using the ch08_saleco database write 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 customer code equals the invoice customer code.  (hint:  exists)


Using the ch08_saleco database write a T-SQL query to display the customer code, customer last name, and customer phone for phone numbers begin with the prefix 894.


Using the ch08_saleco database write 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)