Question d’entretien chez Oracle

Write an sql query which involved joins