Queries: Write the following SELECT statements that return the following to test your work. Write these as CREATE VIEW statements. (Concatenate names with a blank between first and last name)
a. Car Seller List: Company name, contact name, street, city, state, zip, phone, fax, ordered by Company Name.
b. Vehicle Sales List: Invoice Number, Salesperson name, Approved by Name, VIN, Make, Model, Trade-In Vin, Trade-In Make, Trade-In Model, Selling price, Shipping, Discount, Trade-In Allowance, Subtotal, Taxes, Misc, Total Selling Price (Order by Invoice Number)
c. Vehicle Purchase List: Purchase Order Number, Company Name, Contact Name, VIN, Make, Model, Sales Amount, Shipping, Taxes, Total Price, Manager Named.
d. Service Invoice List: Invoice Number, Customer Name, VIN, Make, Model, Mileage, Total Service Charge, Total Parts Charge, Total Charges, Taxes, Misc, Total Charges