From the following tables, write a SQL query to find those match(s) where the 2nd highest stoppage time had been added in the second half of play
- برمجة سي كيو ال sql
- 2021-09-04
- mhanasmh00489829403
الأجوبة
SELECT a.match_no, c.country_name, a.stop2_sec
FROM match_mast a
JOIN match_details b ON a.match_no=b.match_no
JOIN soccer_country c ON b.team_id=c.country_id
WHERE (2-1) = (
SELECT COUNT(DISTINCT(b.stop2_sec))
FROM match_mast b
WHERE b.stop2_sec > a.stop2_sec);Sample Output:
match_no | country_name | stop2_sec
----------+--------------+-----------
15 | France | 374
15 | Albania | 374
(2 rows)أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال