This was a SQL question where there were 2 tables and some data was inserted in them. You were needed to write a Query based on some conditions. The topics which you may need to know, to be able to write that query are: JOINS COUNT GROUP BY CONDITIONS AS keyword and of course knowledge of SQL :P