HERE Technologies interview question

SQL all types select queries should have very clear