From the following table, write a SQL query to count the number of venues for EURO cup 2016. Return number of venues

hamza

Save to bookmark

2022-05-18

140

From the following table, write a SQL query to count the number of venues for EURO cup 2016. Return number of venues.

 venue_id |       venue_name        | city_id | aud_capacity
----------+-------------------------+---------+--------------
    20001 | Stade de Bordeaux       |   10003 |        42115
    20002 | Stade Bollaert-Delelis  |   10004 |        38223
    20003 | Stade Pierre Mauroy     |   10005 |        49822
    20004 | Stade de Lyon           |   10006 |        58585
    20005 | Stade VElodrome         |   10007 |        64354
    20006 | Stade de Nice           |   10008 |        35624
    20007 | Parc des Princes        |   10001 |        47294
    20008 | Stade de France         |   10002 |        80100
    20009 | Stade Geoffroy Guichard |   10009 |        42000
    20010 | Stadium de Toulouse     |   10010 |        33150

Sql programming,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

SELECT COUNT(*) 
FROM soccer_venue;

Sample Output:

 count
-------
    10
(1 row)

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

From the following table, write a SQL query to count the number of venues for EURO cup 2016. Return number of venues

All Answers

Similar questions

need a help?

find thousands of online teachers now