SQL exercises on soccer Database: Find the number of booking happened in each half of play within normal play schedule
SQL soccer Database: Exercise-27 with Solution
27. Write a query in SQL to find the number of booking happened in each half of play within normal play schedule.
Sample table: player_booked
SELECT play_half,play_schedule,COUNT(*) FROM player_booked WHERE play_schedule='NT' GROUP BY play_half,play_schedule;
play_half | play_schedule | count -----------+---------------+------- 1 | NT | 61 2 | NT | 123 (2 rows)
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?