Write SQL query for the following

- the number of volcanos per country

- the number of volcanos of each type

- VEI summary statistics

- Elevation summary statistics

- the most active volcanos (repeated eruptions)

 

Transcribed Image Text:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 RECNO YEAR MONTH DAY NAME 98 1598 (null) (null) Banda Api 99 1600 100 1606 1608 101 102 1609 (null) (null) Tengchong 103 1615 3 (null) Banda Api 104 1617 (null) (nul1) Fuego 105 1625 2 Katla 106 1629 (null) (null) Grimsvotn 107 1630 108 1631 109 1631 110 1636 2 1 7 9 9 2 12 5 19 Huaynaputina 23 Hachijo-jima 18 Gamalama 3 Furnas 14 Dama Ali 16 Vesuvius 15 Hekla 1638 (null) (nul1) Raung 7 9 111 112 1640 7 31 Komaga-take 113 1640 (null) (null) Tungurahua 114 1646 19 Makian 115 1650 26 Santorini LOCATION Banda Sea Peru Izu Is-Japan Halmahera-Indonesia China-S Banda Sea Guatemala Iceland-S Iceland-NE Azores Africa-NE Italy Iceland-S Java Hokkaido-Japan Ecuador COUNTRY Pacific Ocean Peru Japan Indonesia Greece China Pacific Ocean Guatemala Iceland Iceland Portugal Ethiopial Japan Ecuador Halmahera-Indonesia Indonesia Greece Italy Iceland. Indonesia LATITUDE LONGITUDE 129.871 -70.85 139.77 127.325 98.47 129.871 -90.88 -19.05 -17.33 -25.32 41.63 14.426 -19.7 114.042 140.68 -78.442 127.4 25.396 -4.525 -16.608 33.13 0.8 25.32 -4.525 14.473 63.63 64.42 37.77 11.28 40.821 63.98 -8.125 42.07 -1.467 0.32 36.404 ELEVATION TYPE VEI 3763 Stratovolcano 1512 Subglacial volcano 1725 Caldera 805 Stratovolcano 1068 Shield volcano 1281 Complex volcano. 1491 Stratovolcano 3332 Stratovolcano 1140 Stratovolcano 5023 Stratovolcano 1357 Stratovolcano 329 Shield volcano. 640 Caldera 4850 Stratovolcano 854 Stratovolcano. 1715 Stratovolcano 2865 Pyroclastic cone. (null) 640 Caldera DEATHS 3 (null) 6 2 1500 (null) (null) (null) 3 3 (null) 3 (null) 5 (null) 2 4 (null) 5 4 200 50 4000 (null) 4 1001 5 (null) 3 5000 4 (null) 3 4 120 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 RECNO YEAR MONTH DAY NAME 98 1598 (null) (null) Banda Api 99 1600 100 1606 1608 101 102 1609 (null) (null) Tengchong 103 1615 3 (null) Banda Api 104 1617 (null) (nul1) Fuego 105 1625 2 Katla 106 1629 (null) (null) Grimsvotn 107 1630 108 1631 109 1631 110 1636 2 1 7 9 9 2 12 5 19 Huaynaputina 23 Hachijo-jima 18 Gamalama 3 Furnas 14 Dama Ali 16 Vesuvius 15 Hekla 1638 (null) (nul1) Raung 7 9 111 112 1640 7 31 Komaga-take 113 1640 (null) (null) Tungurahua 114 1646 19 Makian 115 1650 26 Santorini LOCATION Banda Sea Peru Izu Is-Japan Halmahera-Indonesia China-S Banda Sea Guatemala Iceland-S Iceland-NE Azores Africa-NE Italy Iceland-S Java Hokkaido-Japan Ecuador COUNTRY Pacific Ocean Peru Japan Indonesia Greece China Pacific Ocean Guatemala Iceland Iceland Portugal Ethiopial Japan Ecuador Halmahera-Indonesia Indonesia Greece Italy Iceland. Indonesia LATITUDE LONGITUDE 129.871 -70.85 139.77 127.325 98.47 129.871 -90.88 -19.05 -17.33 -25.32 41.63 14.426 -19.7 114.042 140.68 -78.442 127.4 25.396 -4.525 -16.608 33.13 0.8 25.32 -4.525 14.473 63.63 64.42 37.77 11.28 40.821 63.98 -8.125 42.07 -1.467 0.32 36.404 ELEVATION TYPE VEI 3763 Stratovolcano 1512 Subglacial volcano 1725 Caldera 805 Stratovolcano 1068 Shield volcano 1281 Complex volcano. 1491 Stratovolcano 3332 Stratovolcano 1140 Stratovolcano 5023 Stratovolcano 1357 Stratovolcano 329 Shield volcano. 640 Caldera 4850 Stratovolcano 854 Stratovolcano. 1715 Stratovolcano 2865 Pyroclastic cone. (null) 640 Caldera DEATHS 3 (null) 6 2 1500 (null) (null) (null) 3 3 (null) 3 (null) 5 (null) 2 4 (null) 5 4 200 50 4000 (null) 4 1001 5 (null) 3 5000 4 (null) 3 4 120

Answer rating: 100% (QA)

Assuming you have a table named volcanoes with columns country type VEI elevation and name here are ... View the full answer