Student projectsChallengeProject 1RRohind C19 Nov 2022ER diagram, table structure and the query are in the pdf that is attached.