-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)