SQL Query Question Asked During Interview - Part 2
Continuing our series on SQL Query Questions Asked During Interview. This is part 2. You can find part 1 here You might not encounter the following scenario in real-time projects, however, it would help you exercise your SQL skills and might help if you are preparing for an Interview. Please refer to the picture below. On the left side, you have a table with a single column called teamname which consists of various acronyms of countries situated in Asia that play cricket. And on the right side, is the expected output. Essentially, we need to come up with the fixtures of teams playing each other and no two teams playing twice . Common give it a try For answer and explanation, refer to the video below