SQL exercises on soccer Database: Count the number of matches ended with a results in group stage
SQL soccer Database: Basic Exercise-8 with Solution
8. Write a query in SQL to count the number of matches ended with a results in group stage.
Sample table: match_mast
SELECT COUNT(*) FROM match_mast WHERE results='WIN' AND play_stage='G';
count ------- 25 (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?