CREATE TABLE chip_model (model_name CLOB, launch_year NUMBER, ram_mib NUMBER, rom_mib NUMBER, slots CLOB, wifi CLOB, bluetooth 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 phone (company_name CLOB, hardware_model_name CLOB, accreditation_type CLOB, accreditation_level CLOB, date CLOB, chip_model CLOB, screen_mode CLOB)

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'
SELECT "t1"."pixels" FROM "screen_mode" "t1" JOIN "phone" "t2" ON "t1"."graphics_mode" = "t2"."screen_mode" AND "t2"."accreditation_type" = 'Provisional' INTERSECT SELECT "t1"."pixels" FROM "screen_mode" "t1" JOIN "phone" "t2" ON "t1"."graphics_mode" = "t2"."screen_mode" AND "t2"."accreditation_type" = 'Full'