Fill in the blanks in the SQL statement below that will list...

Fill in the blanks in the SQL statement below that will list the invoice_id, invoice_total and the invoice_date for invoices with amounts over $1000. Format the invoice date as MM/DD/YYYY (example: 3/28/2017). Round invoice amount to one decimal place. SELECT invoice_id, DATE_FORMAT(invoice_date, FROM invoices WHERE invoice_total > 1000;

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

Aarya B.

Question

Please give Ace some feedback