How to display the entire column in a group by

Question

I have two tables teamand bobotteam, and then I tried this query:

SELECT team.id , bobotteam.teamfight/MAX(bobotteam.teamfight)
    FROM team
    INNER JOIN bobotteam on team.id = bobotteam.id

Why is the data showing only 1 data, although I have two data in the table bobotteam. IMAGE

Answer 1

Please try the following:

SELECT team.id , bobotteam.teamfight/(select MAX(bobotteam.teamfight) from bobotteam)
FROM team
INNER JOIN bobotteam on team.id = bobotteam.id