Intel Corporation interview question

sql joins group by and so on