|
Author | S. Moiseenko |
|
|
| Point out the names, displacements and number of guns of ships participating in the battle at Guadalcanal. |
|
Author | S. Moiseenko |
|
|
| Find the classes including only one ship in the database ( taking into account Outcomes table ). |
|
Author | S. Moiseenko |
|
|
| Find the countries having classes of both ordinary ships and cruisers. |
|
Author | S. Moiseenko |
|
|
| Define the ships that "survived for future battles"; being damaged in one battle, they took part in another. |
|
Author | S. Moiseenko |
|
|
| Define the names of all ships in the database launched before 1941. |
|
Author | S. Moiseenko |
|
|
|
For each battle find out the first and the last day of the month when the battle took place.
Result set: tne battle name, the first day of month, the last day of month.
|
|
Author | S. Moiseenko |
|
|
| For each country, find the year, in which the maximal number of ships had been launched.
In the case of more than one year in question, take a minimal year. Result set : country ,
number of ships , year. |
|
Author | S. Moiseenko |
|
|
| Point out the battles in which at least three ships of the same country took part. |
|
Author | S. Moiseenko |
|
|
| The weight of a shell fired by the gun, in pounds, is nearly equal to half the cube of its caliber.
Define the average weight of shells for ships of each country. Take into account the ships from the
Outcomes table, too. |
|
Author | S. Moiseenko |
|
|
| Find the names of the ships having the largest amount of guns among all the ships with the
same displacement (taking into account Outcomes table). |
|
Author | S. Moiseenko |
|
|
| To within two decimal digits, define the average amount of guns for the battleship classes. |
|
Author | S. Moiseenko |
|
|
| To within two decimal digits, define the average amount of guns for all the battleships
(taking into account Outcomes table). |
|
Author | S. Moiseenko |
|
|
| For each class, define the year in which the first ship of this class was launched.
Result set : class , year. |
|
Author | S. Moiseenko |
|
|
| For each class, define the number of ships of this class that were sunked in a battles. Result set: class, number of sunked ships. |
|
Author | S. Moiseenko |
|
|
| For every class that has not less than 3 ships in the database determine the number of ships
of this class sunk in the battles, if any. Output: class and the number of the sunken
ships. |