Can you help me to do it in mysql workbench, XMAPP 4. Exercise 6.4.7: Write the following

Can you help me to do it in mysql workbench, XMAPP

   

Transcribed Image Text:

4. Exercise 6.4.7: Write the following queries, based on the database schema ) Classes (class, type, country, numGuns, bore, displacement Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result ) of Exercise 2.4.3. and evaluate your queries using the data of that exercise. a) Find the number of battleship classes. b) Find the average number of guns of battleship classes. c) Find the average number of guns of battleships. Note the difference between b) and c); do we weight a class by the number of ships of that class or not? d) Find for each class the year in which the rst ship of that class was launched. e) Find for each class the number of ships of that class sunk in battle. 4. Exercise 6.4.7: Write the following queries, based on the database schema ) Classes (class, type, country, numGuns, bore, displacement Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result ) of Exercise 2.4.3. and evaluate your queries using the data of that exercise. a) Find the number of battleship classes. b) Find the average number of guns of battleship classes. c) Find the average number of guns of battleships. Note the difference between b) and c); do we weight a class by the number of ships of that class or not? d) Find for each class the year in which the rst ship of that class was launched. e) Find for each class the number of ships of that class sunk in battle.

Answer rating: 100% (QA)

a Find the number of battleship classes SELECT COUNTDISTINCT class AS numclasses FROM Classe... View the full answer