Skip to content
Advertisement

sql-ex exercise 39 failed on second server error?

Exercise 39: Define the ships that “survived for future battles”; being damaged in one battle, they took part in another.

Database Schema: http://www.sql-ex.ru/help/select13.php#db_3

My approach:

sql-ex says

Your query produced correct result set on main database, but it failed test on second, checking database

correct result matched with my output.

Where I failed?

Advertisement

Answer

Solved! needed to add Distinct

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement