text: CREATE TABLE phone (Accreditation_level VARCHAR) -- Find the accreditation level that more than 3 phones use. SELECT Accreditation_level FROM phone GROUP BY Accreditation_level HAVING COUNT(*) > 3 CREATE TABLE chip_model (Id VARCHAR) -- Find the details for all chip models. SELECT * FROM chip_model CREATE TABLE chip_model (wifi VARCHAR) -- How many models do not have the wifi function? SELECT COUNT(*) FROM chip_model WHERE wifi = 'No' CREATE TABLE chip_model (model_name VARCHAR, launch_year VARCHAR) -- List all the model names sorted by their launch year. SELECT model_name FROM chip_model ORDER BY launch_year CREATE TABLE chip_model (RAM_MiB INTEGER, model_name VARCHAR, chip_model VARCHAR); CREATE TABLE phone (RAM_MiB INTEGER, model_name VARCHAR, chip_model VARCHAR) -- Find the average ram mib size of the chip models that are never used by any phone. SELECT AVG(RAM_MiB) FROM chip_model WHERE NOT model_name IN (SELECT chip_model FROM phone) CREATE TABLE chip_model (model_name VARCHAR, chip_model VARCHAR, Accreditation_type VARCHAR); CREATE TABLE phone (model_name VARCHAR, chip_model VARCHAR, Accreditation_type VARCHAR) -- Find the names of the chip models that are not used by any phone with full accreditation type. SELECT model_name FROM chip_model EXCEPT SELECT chip_model FROM phone WHERE Accreditation_type = 'Full' CREATE TABLE phone (screen_mode VARCHAR, Accreditation_type VARCHAR); CREATE TABLE screen_mode (pixels VARCHAR, Graphics_mode VARCHAR) -- Find the pixels of the screen modes that are used by both phones with full accreditation types and phones with Provisional accreditation types. SELECT t1.pixels FROM screen_mode AS t1 JOIN phone AS t2 ON t1.Graphics_mode = t2.screen_mode WHERE t2.Accreditation_type = 'Provisional' INTERSECT SELECT t1.pixels FROM screen_mode AS t1 JOIN phone AS t2 ON t1.Graphics_mode = t2.screen_mode WHERE t2.Accreditation_type = 'Full'