Intel Corporation Interview Question

sql joins group by and so on