Yelp interview question

Some basic question about SQL and networking