The answer of 5.5 is wrong

[Aheadboy]

The correct answer is

[AbhishekAnand01]

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