From the following tables, write a SQL query to find the teams played the match where second highest stoppage time had been added in second half of play. Return country name of the teams
- برمجة سي كيو ال sql
- 2021-09-04
- mhanasmh00489829403
الأجوبة
SELECT country_name
FROM soccer_country
WHERE country_id IN(
SELECT team_id
FROM match_details
WHERE match_no IN(
SELECT match_no
FROM match_mast
WHERE stop2_sec=(
SELECT max(stop2_sec)
FROM match_mast
WHERE stop2_sec<>(
SELECT max(stop2_sec)
FROM match_mast))));Sample Output:
country_name -------------- Albania France (2 rows)
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال