SQL exercises on soccer Database: Find the number of matches ended with a result
SQL soccer Database: Basic Exercise-4 with Solution
4. Write a query in SQL to find the number of matches ended with a result.
Sample table: match_mast
SELECT COUNT(*) FROM match_mast WHERE results='WIN';
count ------- 40 (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?