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'
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 where t2 . accreditation_type = value intersect select t1 . pixels from screen_mode as t1 join phone as t2 on t1 . graphics_mode = t2 . screen_mode where t2 . accreditation_type = value
Find the pixels of the screen modes that are used by both phones with full accreditation types and phones with Provisional accreditation types .