SQL exercises on soccer Database: Find the match no in which Germany played against Poland
SQL soccer Database: Subqueries Exercise-4 with Solution
4. Write a query in SQL to find the match no in which Germany played against Poland.
Sample table: match_details
Sample table: soccer_country
SELECT match_no FROM match_details WHERE team_id=( SELECT country_id FROM soccer_country WHERE country_name='Germany') OR team_id=( SELECT country_id FROM soccer_country WHERE country_name='Poland') GROUP BY match_no HAVING COUNT(DISTINCT team_id)=2;
match_no ---------- 18 (1 row)
Sample Database: soccer
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query in SQL to find the match with match no, play stage, goal scored, and the audence which was the heighest audence match.
Next: Write a query in SQL to find the match no, play stage, date of match, number of gole scored, and the result of the match where Portugal played against Hungary.
What is the difficulty level of this exercise?