Pergunta de entrevista da empresa KBC

I was asked SQL SELECT optional clauses