SQL-exercise
SQL-exercise copied to clipboard
The answer of 5.5 is wrong
The correct answer is

Hi,
Just checked Question No 5.5, I think you are talking about Question no 5.6.
Answer of question No 5.5 is correct, I am sharing one more alternate answer.
SELECT Pieces.Name,Providers.Code from Pieces inner join Provides on Pieces.Code=Provides.Piece inner join Providers on Providers.Code=Provides.Provider where Providers.Code='HAL'
Regads, Abhishek Anand