how can i select the player with the most goals of each team using subquery?

Danicrod's profile image Danicrod posted 2 years ago in General Permalink

This is the structure:

CREATE TABLE Jugadores ( codJ INT(5), nombreJ VARCHAR(55), goles INT(10),

PRIMARY KEY(codJ)

);

CREATE TABLE Equipos ( codEquipo INT(5), codJ INT(5), nombreE VARCHAR(55),

PRIMARY KEY (codEquipo),
FOREIGN KEY (codJ) REFERENCES Jugadores (codJ)

);

Please login to leave a reply, or register at first.