From the following tables, write a SQL query to count number of goals that has seen. Return venue name and number of goals. Sample table: soccer_country
- برمجة سي كيو ال sql
- 2021-09-04
- mhanasmh00489829403
الأجوبة
SELECT venue_name, count(venue_name)
FROM goal_details
JOIN soccer_country
ON goal_details.team_id=soccer_country.country_id
JOIN match_mast ON goal_details.match_no=match_mast.match_no
JOIN soccer_venue ON match_mast.venue_id=soccer_venue.venue_id
GROUP BY venue_name
ORDER BY COUNT(venue_name) DESC;Sample Output:
venue_name | count -------------------------+------- Stade de France | 18 Stade de Lyon | 16 Stade Pierre Mauroy | 13 Stade de Bordeaux | 13 Stade VElodrome | 11 Stadium de Toulouse | 9 Stade de Nice | 8 Stade Geoffroy Guichard | 8 Stade Bollaert-Delelis | 7 Parc des Princes | 5
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال