JMAN Group interview question

Asked a question in SQL from hackerrank, they will ask random querry related to the database and join