Write SQL codes according to the requirements given. Tables are imaginary, column names can be made up. a. For each invoice, list the invoice number and invoice date along with the ID, first name, and last name of the customer for which the invoice was created.
b. For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer for which the invoice was created.
c. For each invoice, list the invoice number, invoice date, item ID, quantity ordered, and quoted price for each invoice line that makes up the invoice.