Using the following schema for vendor table vendor_id INT PRIMARY KEY vendor_name VARCHAR(50) NOT NULL vendor_address1 VARCHAR(50) vendor_address 2 VARCHAR(50) vendor_city VARCHAR(50) NOT NULL vendor_state CHAR(2) vendor_zip_code VARCHAR(50) vendor_phone VARCHAR(50) vendor_contact_last_name VARCHAR(50) vendor_contact_first_name VARCHAR(50) default_terms_id INT default_account_number INT To retrieve a list of zip codes for all vendors in the 559 telephone area code in zip_code order, use the select statement select zip_code from vendors where ... The remainder of the query could be where vendor_phone_area_code = '559' order by zip_code where vendor_phone like '(559)%' order by zip_code where vendor_phone like '(559)" order by 1 where vendor_phone = '(559)%' order by zip_code