SQL exercises on soccer Database: Find the number of goals Germany scored at the tournament

Last update on May 30 2022 07:30:56 (UTC/GMT +8 hours)

SQL soccer Database: Subqueries Exercise-17 with Solution

17. From the following tables, write a SQL query to find the number of goals Germany scored at the tournament.

Sample table: goal_details

Sample table: soccer_country

Sample Solution:

SQL Code:

SELECT COUNT(player_id) 
FROM goal_details 
WHERE team_id=
(
SELECT country_id 
FROM soccer_country
WHERE country_name='Germany'
);

Sample Output:

 count
-------
     7
(1 row)

Sample Database: soccer

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find the goalkeeper for Italy in penalty shootout against Germany in Football EURO cup 2016. Return goalkeeper name.
Next: From the following tables, write a SQL query to find the players who were the goalkeepers of England squad in 2016-EURO cup. Return player name, jersey number, club name.

SQL: Tips of the Day

SQL Server SELECT into existing table.

INSERT INTO dbo.TABLETWO SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO (col1, col2) SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3