{"action":"closed","issue":{"url":"https://api.github.com/repos/datacarpentry/semester-biology/issues/469","repository_url":"https://api.github.com/repos/datacarpentry/semester-biology","labels_url":"https://api.github.com/repos/datacarpentry/semester-biology/issues/469/labels{/name}","comments_url":"https://api.github.com/repos/datacarpentry/semester-biology/issues/469/comments","events_url":"https://api.github.com/repos/datacarpentry/semester-biology/issues/469/events","html_url":"https://github.com/datacarpentry/semester-biology/issues/469","id":173560928,"number":469,"title":"Answer to Intro SQL #8 probably not quite right","user":{"login":"ethanwhite","id":744427,"avatar_url":"https://avatars.githubusercontent.com/u/744427?v=3","gravatar_id":"","url":"https://api.github.com/users/ethanwhite","html_url":"https://github.com/ethanwhite","followers_url":"https://api.github.com/users/ethanwhite/followers","following_url":"https://api.github.com/users/ethanwhite/following{/other_user}","gists_url":"https://api.github.com/users/ethanwhite/gists{/gist_id}","starred_url":"https://api.github.com/users/ethanwhite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ethanwhite/subscriptions","organizations_url":"https://api.github.com/users/ethanwhite/orgs","repos_url":"https://api.github.com/users/ethanwhite/repos","events_url":"https://api.github.com/users/ethanwhite/events{/privacy}","received_events_url":"https://api.github.com/users/ethanwhite/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-26T23:14:20Z","updated_at":"2016-08-30T18:15:38Z","closed_at":"2016-08-30T18:15:38Z","body":"> Write a query that returns the number of individuals of all species combined (total_abundance) in each year, sorted chronologically. Include the year in the output. Save it as total_abundance_by_year.\r\n\r\nA student reports that if you `COUNT(*)` to count all of the individuals you get a different answer that the one of the site, but if you `COUNT(species)` you get the same answer. We should either clarify #8 to make the current answer correct or update the answer to `COUNT(*)`."}}
{"actor":{"display_login":"brymz"}}