Concord USA interview question

Question on Micro-strategy, Business Intelligence, SQL Limit function, Joins, Few Queries & previous work.