Rootquotient interview question

SQL query related to project schema