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. 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 Bill 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 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 H'S 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 ap Tables general_ledger_accounts Columns account_number account_description Indexes PRIMARY account_description Foreign Keys Triggers invoice_archive Columns invoice_id vendor_id invoice_number invoice_date invoice_total payment_total credit_total terms_id invoice_due_date payment_date Indexes Foreign Keys Triggers invoice_line_items Columns invoice_id invoice_sequence account_number line_item_amount line_item_description Indexes Indexes PRIMARY line_items_fk_acounts Foreign Keys |line_items_fk_acounts line_items_fk_invoices Triggers invoices Columns invoice_id vendor_id invoice_number invoice_date invoice_total payment_total credit_total terms_id invoice_due_date payment_date Indexes PRIMARY invoices_fk_vendors invoices_fk_terms invoices_invoice_date_ix Foreign Keys invoices_fk_terms invoices_fk_vendors Triggers terms Columns terms_id terms_description terms_due_days Indexes PRIMARY Foreign Keys Triggers vendor_contacts Columns Indexes Foreign Keys Triggers vendors Columns Indexes Foreign Keys Triggers Views Stored Procedures Functions