CREATE TABLE phone (Hardware_Model_name VARCHAR, Company_name VARCHAR, Accreditation_type VARCHAR)

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 'Full'