Question d’entretien chez Oracle

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