Rootquotient Interview Question

SQL query related to project schema