i think the option D is correct coz given query 2 having inner query first check the condition that exists given and accordingly that is perform the operation while in first query it displays all the table just checking the condition which results in more columns