Database: phone_1
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';