CREATE TABLE phone (company_name CLOB, hardware_model_name CLOB, accreditation_type CLOB, accreditation_level CLOB, date CLOB, chip_model CLOB, screen_mode CLOB)
CREATE TABLE screen_mode (graphics_mode NUMBER, char_cells CLOB, pixels CLOB, hardware_colours NUMBER, used_kb NUMBER, map CLOB, type CLOB)
CREATE TABLE chip_model (model_name CLOB, launch_year NUMBER, ram_mib NUMBER, rom_mib NUMBER, slots CLOB, wifi CLOB, bluetooth CLOB)

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'