Domanda di colloquio di TekFirst

How would I retrieve data using an SQL query and explain why I used that specific method and not another one.