SQL-Scripts icon indicating copy to clipboard operation
SQL-Scripts copied to clipboard

Update 6-JOIN.sql

Open Sandeep501 opened this issue 5 years ago • 2 comments

SQLZOO Question No 6 : Updated answer as per the Query return value.

Sandeep501 avatar Dec 11 '20 07:12 Sandeep501

Updated Query Results

Sandeep501 avatar Dec 11 '20 07:12 Sandeep501

For the given problem For every match involving 'POL', show the matchid, date and the number of goals scored. why are we doing a count on player instead of mdate?

@Sandeep501

varunu28 avatar Dec 11 '20 15:12 varunu28