KoinWorks interview question

Question related to ERD and Database Query