From the following tables, write a SQL query to count the number of matches played in each venue. Sort the result-set on venue name. Return Venue name, city, and number of matches
- برمجة سي كيو ال sql
- 2021-09-04
- mhanasmh00489829403
الأجوبة
SELECT a.venue_name, b.city, count(c.match_no)
FROM soccer_venue a
JOIN soccer_city b ON a.city_id=b.city_id
JOIN match_mast c ON a.venue_id=c.venue_id
GROUP BY venue_name,city
ORDER BY venue_name;Sample Output:
venue_name | city | count -------------------------+---------------+------- Parc des Princes | Paris | 5 Stade Bollaert-Delelis | Lens | 4 Stade de Bordeaux | Bordeaux | 5 Stade de France | Saint-Denis | 7 Stade de Lyon | Lyon | 6 Stade de Nice | Nice | 4 Stade Geoffroy Guichard | Saint-Etienne | 4 Stade Pierre Mauroy | Lille | 6 Stade VElodrome | Marseille | 6 Stadium de Toulouse | Toulouse | 4 (10 rows)
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال