Exercise #151 page 4

Solution 3.5.3

Console

Execute

SELECT name 
FROM Ships
WHERE launched < 1941 
UNION 
SELECT ship
FROM Outcomes, Battles 
WHERE name = battle AND 
DATEPART(YEAR, date) < 1941
UNION 
SELECT ship
FROM Outcomes
WHERE ship IN (SELECT class
FROM Ships
WHERE launched < 1941
)
UNION
SELECT name
FROM Ships
WHERE name IN (SELECT class
FROM Ships
WHERE launched < 1941
);

How a lot of interesting things can be taken from this problem, only having changed a year!

However it is not yet all. We suggest you to find the additional ships responding conditions of the problem by yourself. Check yourself up by glancing into T&S.

T&S

To solve the problem on SQL-EX.RU

Pages

mistakes ships

Previous [Exercise #39]

[Exercise #(-2)] Next

SQL Problems and solutions

S. I. Moiseenko

Common mistakes in solving SELECT statement exercises

Database «Ships»

Exercise #151 page 4