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)) GO