4. 15 points- SQL queries Write SQL queries using the database schema for World War II Ships: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship.battle, result) Query 1: List for each class the number of ships of that class that was sunk in a battle. Query 2: For each battle, list the number of ships that were launched before the battle, and the number of ships that were either sunk or damaged in the battle