This advanced SQL exercise is part of the book: Advanced SQL – Practical Techniques and Use-Cases, which includes 100 day-to-day SQL challenges (and solutions), need-to-know advanced features, and key concepts.

The “Tsedi” stadium in Tel-Aviv (Israel) is being prepared for the option of hosting the NBA games in the year 2017. For this purpose, the stadium manager have created a table that specifies the following NBA teams (6 teams in total):

CREATE TABLE basketball_teams   
(team_name_1 varchar(25),   
 team_name_2 varchar(25))  

Would you like to read more?