Task: Text to Code
Input (English): Step 1: find the Pixels of screen_mode table for which Type equals Provisional.
Step 2: For each row in screen_mode table, find the corresponding rows in phone table.
Step 3: find Pixels of the results of step 2 whose Accreditation_type equals Full.
Step 4: show the rows that are in both the results of step 1 and the results of step 3
Output (English): SELECT T1.Pixels FROM screen_mode AS T1 WHERE T1.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"