SQL exercises on soccer Database: Find the number of matches decided by penalties in the Round of 16
SQL soccer Database: Basic Exercise-10 with Solution
10. Write a query in SQL to find the number of matches decided by penalties in the Round of 16.
Sample table: match_mast
SELECT COUNT(*) FROM match_mast WHERE decided_by='P' AND play_stage='R';
count ------- 1 (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?