Q1.) (25 points) Use the ap database for this question. Write a query that selects vendors from California and replicates the result set shown below, matching all data and format aspects, including column headers. Pay special attention to the order of rows. NULL Vendor Phone Number City Address Aztek Label Phone : (714) 555-9000 Anaheim Accounts Payable Blue Shield of California Phone #: (415) 555-5103 Anaheim PO Box 7021 Diversified Printing & Pub Phone #: (714) 555-4541 Brea 2632 Saturn St Abbey Office Furnishings Phone #: (559) 555-8300 Fresno 4150 W Shaw Ave ASC Signs Fresno 1528 N Sierra Vista BFI Industries Phone #: (559) 555-1551 Fresno PO Box 9369 Bil Marvin Electric Inc Phone : (559) 555-5106 Fresno 4583 E Home California Business Machines Phone #: (559) 555-5570 Fresno Gallery Plz California Data Marketing Phone #: (559) 555-3801 Fresno 2818 E Hamilton City Of Fresno Phone #: (559) 555-9999 Fresno PO Box 2069 Coffee Break Service Phone #: (559) 555-8700 Fresno PO Box 1091 Costco Fresno Fresno Warehouse Crown Printing Phone #: (559) 555-7473 Fresno 1730 H" St Dataforms/West Fresno 1617 W. Shaw AV... HULLE Digital Dreamworks Fresno 5070 N Sixth Ste. 71 Dristas Groom & McCormick Phone #: (559) 555-8484 Fresno 7112 N Fresno St... Executive Office Products Phone #: (559) 555-1704 Fresno 353 E Shaw Ave Expedata Inc Phone #: (559) 555-9586 Fresno 4420 N. First Stre... The result should contain 75 rows. Only a subset is shown in this preview. e ap - Tables general_ledger_ac... > 5 invoice_archive > invoice_line_items invoices terms vendor_contacts Columns > Indexes > Foreign Keys > Triggers vendors Columns Indexes > 4. Foreign Keys > Triggers 3 Views Stored Procedures 5 Functions