Anheuser-Busch InBev interview question

5-6 sql queries like duplicate, join, rank functions