Skip to content

Instantly share code, notes, and snippets.

@Imperat

Imperat/gist:37759bc3433f9f44dc7890f14f341171

Created October 4, 2016 22:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Imperat/37759bc3433f9f44dc7890f14f341171 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Imperat/37759bc3433f9f44dc7890f14f341171 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Топ-5 лучших бомбардиров в каждом чемпионате! вух вух вух!
select Count(*) as count, Goal.author from Goal inner join Matches on match = Matches.ID
inner join League on Matches.league_id = League.id
where DATEDIFF(day,Matches.date, League.end_date)<32 group by author;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment