text: 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' CREATE TABLE phone (screen_mode VARCHAR, Hardware_Model_name VARCHAR); CREATE TABLE screen_mode (Char_cells VARCHAR, Pixels VARCHAR, Hardware_colours VARCHAR, Graphics_mode VARCHAR) -- Find the Char cells, Pixels and Hardware colours for the screen of the phone whose hardware model name is "LG-P760". SELECT T1.Char_cells, T1.Pixels, T1.Hardware_colours FROM screen_mode AS T1 JOIN phone AS T2 ON T1.Graphics_mode = T2.screen_mode WHERE T2.Hardware_Model_name = "LG-P760" CREATE TABLE phone (Hardware_Model_name VARCHAR, Company_name VARCHAR, screen_mode VARCHAR); CREATE TABLE screen_mode (Graphics_mode VARCHAR, Type VARCHAR) -- List the hardware model name and company name for the phone whose screen mode type is "Graphics." SELECT T2.Hardware_Model_name, T2.Company_name FROM screen_mode AS T1 JOIN phone AS T2 ON T1.Graphics_mode = T2.screen_mode WHERE T1.Type = "Graphics" CREATE TABLE phone (Company_name VARCHAR) -- Find the name of the company that has the least number of phone models. List the company name and the number of phone model produced by that company. SELECT Company_name, COUNT(*) FROM phone GROUP BY Company_name ORDER BY COUNT(*) LIMIT 1