Aug 20

Mike and I were interviewing someone today over skype today. We asked him a SQL question and he answered it without any problems so we decided to ask another one. Here’s what happened.

[5:17:53 PM] Michael says: For the following schema: Athletes(name, country, sport, age, height, weight)
[5:18:22 PM] Michael says: write a SQL query that returns for each sport, the name of the sport, the country that has the most athletes who play that sport, and the number of athletes of that country that play that sport. (note: don’t use temp tables )
[5:20:02 PM] Jason says: …

Leave a Reply