sql question write code in a proper manner

All questions relate to the ap database. Submit all answers on one.sql file. Use comments to include your name and date and to indicate question numbers. Points off for failure to do so. There are usually several ways to get the same output. As long as you use one sql statement per question how you generate the output does not matter. Each problem is worth 10 points. Partial credit given for all attempts. Zero points given if sql statement does not execute and generates error messages 1) Display all vendors from California where the first name of the vendor contact starts with the letter "A". Use proper alias in column headings as shown. Order by vendor name Returns 7 rows. First California Business Machines California Chamber Of Commerce CA CA CA CA CA CA Alexandro CA Anton Costco Franchise Tax Board Fresno Credit Bureau Yale Industrial Trucks-Fresno Aaron Anita 2) Display just the first 10 records from the vendors table with column headings of the company, contact name and address. Sort by the name of the vendor. Output should be identical to output below Abbev Office Furnishinos American Bookselers Assoc American Exoress ASC Sians Ascom Hasler Mailina Svstems Darnel Lewis AT&T Aztek Label Baker & Tavlor Books Bertelsmann Industrv Svcs. Inc Lance Potter BFI Industries Kvra Frandis Nashalie Angelica 828 SBroadwav Tarrvtown. NY 10591 Kirsten Storv Elisabeth Darien 1528N Sierra Vista Fresno. CA 93703 4150 W Shaw Ave Fresno. CA 93722 Box 0001 Los Angeles. CA 90096 Alisha Weslev Brian Griffin Brittnee Bernardo Five Lakeoointe Plaza. Ste 500 Charlotte. NC 2.. PO Box 895 Shelton. CT 06484 PO Box 78225 Phoenix. AZ 85062 Accounts Pavable Anaheim. CA 92807 28210 N Avenue Stanford Valencia. CA 91355 PO Box 9369 Fresno. CA 93792 Erick Kaleich