Write the SQL to retrieve a list of all customers that live in Texas (TX). Include the customer's first and last name, their account number and their representative's name and number.
Using the tables in Premier Products, create an inventory report that lists the part number, part description, and current inventory level for all parts that have fallen below the inventory level of 7 on hand.
Write the SQL to create a promotional mailing list including the customer's first and last name, their street address, city, state and zip code. Only customers that have a credit limit of $10,000 or more OR that have previously ordered part number KL62 should be included on the list.
Write the SQL to prepare a sales report for October listing the total amount of sales.