Mаstery Assessment These аre the prоblems tо cоpy. Reаd the requirements above. When complete upload your solution using the link below. You have one hour to complete this mastery. Queries: Use the AP database to make a copy of the following tables: vendors table as Vendors_Copy, invoices table as Invoices_Copy, invoice_line_items table as Invoice_Line_Items_Copy. Write a statement that displays all vendors from the state of California. Include the following fields: vendor's name, phone. Use the IN keyword with a subquery. Use Vendors_Copy table. Write a statement that will display the name and zip code from the Vendors_Copy table that has an invoice number of 963253251 from the Invoices_Copy table. Use an equal (=) sign when comparing and NOT the IN operator with a sub query. Write the statement to display the following columns in the Invoice_Line_Items_Copy table: the line item description, the count of those line items (will not use a specific field), and the average price of the line items. Write the statement to display these columns in the Invoice_Line_Items_Copy table: the line item description, the highest price of the line items, the average price of the line items rounded to 2 decimal places. Drop all Copy tables using the correct database and in the correct order. Mastery Assessment M4:Honorlock Mastery Rubric Mastery Assessment M4:Honorlock Mastery Rubric Criteria Ratings & Points 1. The SQL Script has the students name as a comment at top. The questions are copied over from the instructions in the proper manner, numbered, and commented. Full Marks: 10.0 ptsNo Marks: 0.0 pts 2. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 3. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 4. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 5. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 6. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 7. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts Other Deductions -25 Deductions: 0.0 ptsNo Deductions: 0.0 pts -25 Deductions (0.0 pts): Deductions for items not included in rubric, but expected - naming the file correctly, copying and pasting the questions correctly, numbering the questions, commenting the questions properly, placing your answer after each question, using the USE command properly, and any other mistakes not covered by the rubric.