Pergunta de entrevista da empresa Oracle

Prime number code in preferred language, SQL query on group by.