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
SELECT COUNT(*) FROM goal_details WHERE goal_type='O';
count ------- 3 (1 row)
Sample Database: soccer
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?