Where I work, we have a 4 question SQL test where we sit you in front of a dummy database, give you 4 printed results, and say "make the queries to produce exactly these results." Very very few people get all of them, but it gives us an idea of where somebody is at in their ability and knowledge.
The first is the easiest, and the second one isn't bad. The 3rd and 4th trip up most people though.
The first is the easiest, and the second one isn't bad. The 3rd and 4th trip up most people though.