solve and write proper sql programming

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 Name California Business Machines California Chamber Of Commerce CA CA Anton Anoe CA ron CA Costco Franchise Tax Board Fresno Credt Bureau Yale Industrial Trucks -Fresno Anita Anne CA AlexandrO CA 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 Darnell Lewis ATST Aztek Label Baker & Tavlor Books Bertelsmann Industrv Svcs. Inc Lance Potter BFI Industries Kvra Francdis Nashalie Anoelica 828 S Broadwav 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 Alsha 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