MySQL

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. 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 NULL Fresno 1528 N Sierra Vista BFI Industries Phone #: (559) 555-1551 Fresno PO Box 9369 Bill Marvin E 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 28 18 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 NULL Fresno Fresno Warehouse Crown Printing Phone #: (559) 555-7473 Fresno 1730 * St Dataforms/West Fresno 1617 W. Shaw Av... 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. NULL NULL general_ledger_accounts account_numbe INT account_description VARCHAR(50) Indexes i - 1 1 invoice_archive invoice_id INT vendor_id INT invoice_number VARCHAR(50) invoice_date DATE invoice_total DECIMAL (9,2) payment_total DECIMAL 9,2) credit_total DECMAL(9,2) terms_id INT invoice due date DATE payment_date DATE invoices invoice_id INT vendor_id INT invoice_number VARCHAR 50) invoice_date DATE invoice_total DECIM AL(9.2) payment_total DECIMAL 9,2) credit_total DECIMAL(9,2) terms_id INT invoice due date DATE payment_date DATE Indexes . vendor_contacts vendor_id INT last_name VARCHAR(50) first_name VARCHAR(50) Indexes invoice_line_items invoice_id INT invoice_sequence INT account number INT line_item_amount DECIMAL (9,2) line_item_description VARCHAR(100) Indexes vendors vendor_id INT vendor_name VARCHAR(50) vendor_address1 VARCHAR(50) vendor_address2 VARCHAR(50) vendor_city VARCHAR(50) vendor_state CHAR(2) vendor_zip_code VARCHAR(20) vendor_phone VARCHAR(50) vendor_contact_last_name VARCHAR(50) vendor_contact_first_name VARCHAR(50) default_terms_id INT default_account_number INT Indexes terms terms_id INT terms_description VARCHAR(50) terms_due_days INT Indexes n