SELECT Hardware_Model_name ,  Company_name FROM phone WHERE Accreditation_type LIKE 'Full';
Find all phones that have word 'Full' in their accreditation types. List the Hardware Model name and Company name.
SELECT Hardware_Model_name , Company_name FROM phone WHERE Accreditation_type LIKE 'Full ' ;
select hardware_model_name , company_name from phone where accreditation_type like value
Find all phones that have word 'Full ' in their accreditation types . List the Hardware Model name and Company name .