Exercise 6.1.4: Write the following queries based on the database schema of Exercise 2.4.3:

Classes ( class , type , country , numGuns , bore , displacement )

Ships ( name , class , launched )

Battles ( name , date )

Outcomes ( ship , battle , result )

and show the result of your query on the data of Exercise 2.4.3.

a) Find the class name and country for all classes with at least 10 guns.

b) Find the names of all ships launched prior to 1918, but call the resulting column shipName.

c) Find the names of ships sunk in battle and the name of the battle in which they were sunk.

d) Find all ships that have the same name as their class.

e) Find the names of all ships that begin with the letter R.