Q3.) (25 points) Use the ap database for this question. Write a query that selects vendors and any invoice they have to replicate the result set below, matching all data and format aspects, including column headers. This question includes 3 tables. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL invoice_number invoice_total vendor_name vendor_contact_name vendor_phone vendor_address 203339-13 17.50 Abbey Office Furnishings Reynaldo Suscipe (559) 555-8300 4150 W Shaw Ave American Booksellers Assoc (800) 555-0037 828 S Broadway American Express (800) 555-3344 Box 0001 ASC Signs 1528 N Sierra Vista Ascom Hasler Mailing Systems PO Box 895 AT&T PO Box 78225 Aztek Label (714) 555-9000 Accounts Payable Baker & Taylor Books (704) 555-3500 Five Lakepointe Plaza, Ste 500 509786 6940.25 Bertelsmann Industry Svcs. Inc (805) 555-0584 28210 N Avenue Stanford BFI Industries (559) 555-1551 PO Box 9369 Bill Jones Secretary of State Bill Marvin Electric Inc (559) 555-5106 4583 E Home Blanchard & Johnson Associates Bruce Onandonga (214) 555-3647 27371 Valderas 547481328 224.00 Blue Cross (800) 555-0912 PO Box 9061 547480102 224.00 Blue Cross (800) 555-0912 PO Box 9061 547479217 116.00 Blue Cross (800) 555-0912 PO Box 9061 Blue Shield of California (415) 555-5103 PO Box 7021 Boucher Communications Inc (215) 555-8000 1300 Virginia Dr. Ste 400 587056 2184.50 Cahners Publishing Company (301) 555-2162 Citibank Lock Box 4026 Cal State Termite (559) 555-1534 PO Box 956 California Business Machines Geraldine O'Sullivan (559) 555-5570 Gallery Plz California Chamber of Commerce (916) 555-6670 3255 Ramos Cir California Data Marketing (559) 555-3801 2818 E Hamilton NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL The result set contains 202 rows. Only a subset is shown in the preview. Pay special attention to NULL values. Q3.) (25 points) Use the ap database for this question. Write a query that selects vendors and any invoice they have to replicate the result set below, matching all data and format aspects, including column headers. This question includes 3 tables. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL invoice_number invoice_total vendor_name vendor_contact_name vendor_phone vendor_address 203339-13 17.50 Abbey Office Furnishings Reynaldo Suscipe (559) 555-8300 4150 W Shaw Ave American Booksellers Assoc (800) 555-0037 828 S Broadway American Express (800) 555-3344 Box 0001 ASC Signs 1528 N Sierra Vista Ascom Hasler Mailing Systems PO Box 895 AT&T PO Box 78225 Aztek Label (714) 555-9000 Accounts Payable Baker & Taylor Books (704) 555-3500 Five Lakepointe Plaza, Ste 500 509786 6940.25 Bertelsmann Industry Svcs. Inc (805) 555-0584 28210 N Avenue Stanford BFI Industries (559) 555-1551 PO Box 9369 Bill Jones Secretary of State Bill Marvin Electric Inc (559) 555-5106 4583 E Home Blanchard & Johnson Associates Bruce Onandonga (214) 555-3647 27371 Valderas 547481328 224.00 Blue Cross (800) 555-0912 PO Box 9061 547480102 224.00 Blue Cross (800) 555-0912 PO Box 9061 547479217 116.00 Blue Cross (800) 555-0912 PO Box 9061 Blue Shield of California (415) 555-5103 PO Box 7021 Boucher Communications Inc (215) 555-8000 1300 Virginia Dr. Ste 400 587056 2184.50 Cahners Publishing Company (301) 555-2162 Citibank Lock Box 4026 Cal State Termite (559) 555-1534 PO Box 956 California Business Machines Geraldine O'Sullivan (559) 555-5570 Gallery Plz California Chamber of Commerce (916) 555-6670 3255 Ramos Cir California Data Marketing (559) 555-3801 2818 E Hamilton NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL The result set contains 202 rows. Only a subset is shown in the preview. Pay special attention to NULL values