
SQL exercises on soccer Database: Find the number of self-goals scored in EURO cup 2016
SQL soccer Database: Basic Exercise-7 with Solution
7. Write a query in SQL to find the number of self-goals scored in EURO cup 2016.
Sample table: goal_details
Sample Solution:
SELECT COUNT(*)
FROM goal_details
WHERE goal_type='O';
Sample Output:
count ------- 3 (1 row)
Query Visualization:
Duration:

Rows:

Cost:

Practice Online
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 date when did Football EURO cup 2016 begin.
Next: Write a query in SQL to count the number of matches ended with a results in group stage.
What is the difficulty level of this exercise?
New Content: Composer: Dependency manager for PHP, R Programming