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

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