-- Database schema
| chip_model : Model_name [ TEXT ] primary_key , Launch_year [ INT ] , RAM_MiB [ INT ] , ROM_MiB [ INT ] , Slots [ TEXT ] , WiFi [ TEXT ] , Bluetooth [ TEXT ] | screen_mode : Graphics_mode [ INT ] primary_key , Char_cells [ TEXT ] , Pixels [ TEXT ] , Hardware_colours [ INT ] , used_kb [ INT ] , map [ TEXT ] , Type [ TEXT ] | phone : Company_name [ TEXT ] , Hardware_Model_name [ TEXT ] primary_key , Accreditation_type [ TEXT ] , Accreditation_level [ TEXT ] , Date [ TEXT ] , chip_model [ TEXT ] phone.chip_model = chip_model.Model_name , screen_mode [ TEXT ] phone.screen_mode = screen_mode.Graphics_mode |
-- -- 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';