Schema: CREATE TABLE phone (Hardware_Model_name VARCHAR, Company_name VARCHAR, Accreditation_type VARCHAR)
Question: Find all phones that have word 'Full' in their accreditation types. List the Hardware Model name and Company name.
SQL: SELECT Hardware_Model_name, Company_name FROM phone WHERE Accreditation_type LIKE 'Full'