w3resource
Soccer Database Exercises

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


Sample Solution:

SQL Code:

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;

Sample Output:

 match_no
----------
       18
(1 row)

Query Visualization:

Duration:

Query visualization of Find the match no in which Germany played against Poland - Duration

Rows:

Query visualization of Find the match no in which Germany played against Poland - Rows

Cost:

Query visualization of Find the match no in which Germany played against Poland - Cost

Practice Online


Sample Database: soccer

soccer database relationship structure

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?



New Content: Composer: Dependency manager for PHP, R Programming