Altimetrik interview question

JOINS, CASE, WHERE questions and SQL Basic queries.