SQL exercises on soccer Database: Find the number of booking happened in extra time
SQL soccer Database: Exercise-29 with Solution
29. Write a query in SQL to find the number of booking happened in extra time.
Sample table: player_booked
SELECT COUNT(*) FROM player_booked WHERE play_schedule='ET';
count ------- 7 (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?