16:03

	Content	Login

SQL Problems and solutions S. I. Moiseenko

Content

SQL console

back go forward

Typical mistakes at the solution of SELECT statement exercises

Database «Ships»

Exercise #19 (rating) 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 exercise 19

Previos [Exercise #39]

[Exercise #(-2)] Next

Last added:

Tags

aggregate functions ALL ASCII AVG Battles Bezhaev Bismarck C.J.Date Cartesian product CASE cast CHAR CHARINDEX classes COALESCE common table expressions comparison predicates Computer firm CONVERT correlated subqueries COUNT CTE data type conversion database schema DATEDIFF DATEPART DATETIME DELETE DISTINCT duplicates EXCEPT exercise (-2) exercise 19 exercise 23 exercise 32 exercise 37 exercise 39 exercise 46 exercise 54 exercise 55 exercise 56 exercise 57 exercise 7 exercise 70 exercise 8 exercises EXISTS FROM FULL JOIN GROUP BY More tags

The book was updated
several days ago

SQL Problems and solutions

S. I. Moiseenko

Typical mistakes at the solution of SELECT statement exercises

Database «Ships»

Exercise #19 (rating) page 4