Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

matchid, teamid, player, gtime,SELECT player, teamid, COUNT(*) FROM game JOIN goal ON matchid = id WHERE (team1 = "GRE" OR team2 = "GRE") AND teamid != 'GRE' GROUP BY player, teamid id, teammatchid, teamid, player, gtime, id, teamname, coachname, c

Add Answer
Annoying Anaconda answered on February 25, 2024 Popularity 1/10 Helpfulness 1/10

Contents

  • answer matchid, teamid, player, gtime,SELECT player, teamid, COUNT(*) FROM game JOIN goal ON matchid = id WHERE (team1 = "GRE" OR team2 = "GRE") AND teamid != 'GRE' GROUP BY player, teamid id, teammatchid, teamid, player, gtime, id, teamname, coachname, c

    • More Related Answers


    matchid, teamid, player, gtime,SELECT player, teamid, COUNT(*) FROM game JOIN goal ON matchid = id WHERE (team1 = "GRE" OR team2 = "GRE") AND teamid != 'GRE' GROUP BY player, teamid id, teammatchid, teamid, player, gtime, id, teamname, coachname, c

    Comment
    0
    Popularity 1/10 Helpfulness 1/10 Language whatever
    Source: sqlzoo.net
    Tags: c group-by join whatever where
    Link to this answer
    Share Copy Link
    Annoying Anaconda
    Contributed on Feb 25 2024
    Annoying Anaconda
    0 Answers  Avg Quality 2/10

    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.