MySQL Questions

Write a SELECT statement that returns one column from the Vendors table named full_name that joins the vendor_contact_last_name and vendor_contact_first_name columns.

Sort the result set by last name and then first name in ascending sequence. Return only the contacts whose last name begins with the letter A, B, C, or E

MySQL Workbench - O X Local instance MySQL80 X Edit View Query Database File Server Tools Scripting Help SQLAdditions SQL File 9 X Limit to 1000 rows * 3-02 3 -05 SQL File 8* B250 S 1. SELECT* 1 2 FROM vendors; - 176 1 Navigator SCHEMAS Q Filter objects - Jump to om Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help. sakila sys world Result Grid Result Grid 1 Filter Rows: vendor_id vendor_name US Postal Service National Information Data Ctr Register of Copyrights Jobtrak Newbrige Book Clubs California Chamber of Commerce Towne Advertiser's Mailing Svcs BFI Industries Parifir Gas & Flertrir HNM i NULL Edit: 4 3 Export/Import: Wrap Cell vendor_address 1 vendor_address2 vendor Attn: Supt. Window Services PO Box 7005 Madison PO Box 96621 Washin Library of Congress Washin 1990 Westwood Blvd Ste 260 NULL Los Ang 3000 Cindel Drive Washin NULL 3255 Ramos Cir Sacram Kevin Minder 3441 W Macarthur Blvd Santa A PO Box 9369 Roy 52001 San Fra NULL Form Editor NULL Fresno co NULL Administration Schemas Field Types Information X vendors 1 x Apply Revert Context Help Snippets Schema:ap Message Output o Action Output # Time Action 1 15:16:45 SELECT * FROM Vendors LIMIT 0, 1000 122 row(s) retumed 2 15:17:48 SELECT vendor_name, vendor_contact_last_name, vendor_contact_fir... Error Code: 1054. Unknown column 'vendor_name' in field list' 3 15:18:09 SELECT vendor_name, vendor_contact_last_name, vendor_contact_fir. 122 row(s) retumed 4 15:18:48 SELECT vendor_name, vendor_contact_last_name, vendor_contact_fir... 122 row(s) retumed 5 15:21:25 SELECT FROM vendors LIMIT 0, 1000 122 row(s) retumed Duration / Fetch 0.000 sec /0.000 sec 0.000 sec 0.015 sec /0.000 sec 0.032 sec /0.000 sec 0.000 sec /0.000 sec Object Info Session Ouers Completed