SQL Subqueries exercises on soccer Database: Find the date when penalty shootout matches played
SQL soccer Database: Subqueries Exercise-32 with Solution
Write a query in SQL to find the date when penalty shootout matches played.
Sample table: match_mast
Sample table: penalty_shootout
SELECT play_date FROM match_mast WHERE match_no IN (SELECT DISTINCT match_no FROM penalty_shootout);
play_date ------------ 2016-07-03 2016-07-01 2016-06-25 (3 rows)
SQL Code Editor:
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?