Pyramid Consulting interview question

simple sql queries