SQL exercises on soccer Database: Find the number of venues for EURO cup 2016
SQL soccer Database: Basic Exercise-1 with Solution
1. Write a query in SQL to find the number of venues for EURO cup 2016.
Sample table: soccer_venue
SELECT COUNT(*) FROM soccer_venue;
count ------- 10 (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?