SQL exercises on soccer Database: Find the number of matches got a result by penalty shootout
SQL soccer Database: Basic Exercise-9 with Solution
9. Write a query in SQL to find the number of matches got a result by penalty shootout.
Sample table: penalty_shootout
SELECT COUNT(DISTINCT match_no) FROM penalty_shootout;
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?