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