Anonymous interview question

Basic SQL queries like joins, windows function