SQL exercises on soccer Database: Find the match where no stoppage time added in 1st half of play
SQL soccer Database: Joins Exercise-19 with Solution
19. Write a query in SQL to find the match where no stoppage time added in 1st half of play.
Sample table: match_details
Sample table: match_mast
Sample table: soccer_country
SELECT match_details.match_no, soccer_country.country_name FROM match_mast JOIN match_details ON match_mast.match_no=match_details.match_no JOIN soccer_country ON match_details.team_id=soccer_country.country_id WHERE stop1_sec=0;
match_no | country_name ----------+-------------- 4 | England 4 | Russia (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?