SQL query returns duplicated and error value

Question

I have the following query but it is returning duplicate and wrong results. Arthur should show 0 and not 30.

Answer 1

I’ve come to the conclusion of how you do:

SELECT Player_name, Subscription_id,Date_subscription,Amount_paid,Attendance_id,Training_date
FROM PLAYER p,SUBSCRIPTION s, Attendance a
WHERE p.SUBSCRIPTION_SUBSCRIPTION_ID = s.SUBSCRIPTION_ID and a.PLAYER_PLAYER_ID = p.PLAYER_ID;