{"action":"created","issue":{"url":"https://api.github.com/repos/DeveloperLiberationFront/ExploringGHTorrent/issues/1","labels_url":"https://api.github.com/repos/DeveloperLiberationFront/ExploringGHTorrent/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/DeveloperLiberationFront/ExploringGHTorrent/issues/1/comments","events_url":"https://api.github.com/repos/DeveloperLiberationFront/ExploringGHTorrent/issues/1/events","html_url":"https://github.com/DeveloperLiberationFront/ExploringGHTorrent/issues/1","id":125056753,"number":1,"title":"Go through the tutorial","user":{"login":"CaptainEmerson","id":5417003,"avatar_url":"https://avatars.githubusercontent.com/u/5417003?v=3","gravatar_id":"","url":"https://api.github.com/users/CaptainEmerson","html_url":"https://github.com/CaptainEmerson","followers_url":"https://api.github.com/users/CaptainEmerson/followers","following_url":"https://api.github.com/users/CaptainEmerson/following{/other_user}","gists_url":"https://api.github.com/users/CaptainEmerson/gists{/gist_id}","starred_url":"https://api.github.com/users/CaptainEmerson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CaptainEmerson/subscriptions","organizations_url":"https://api.github.com/users/CaptainEmerson/orgs","repos_url":"https://api.github.com/users/CaptainEmerson/repos","events_url":"https://api.github.com/users/CaptainEmerson/events{/privacy}","received_events_url":"https://api.github.com/users/CaptainEmerson/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"clarrain","id":13869747,"avatar_url":"https://avatars.githubusercontent.com/u/13869747?v=3","gravatar_id":"","url":"https://api.github.com/users/clarrain","html_url":"https://github.com/clarrain","followers_url":"https://api.github.com/users/clarrain/followers","following_url":"https://api.github.com/users/clarrain/following{/other_user}","gists_url":"https://api.github.com/users/clarrain/gists{/gist_id}","starred_url":"https://api.github.com/users/clarrain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/clarrain/subscriptions","organizations_url":"https://api.github.com/users/clarrain/orgs","repos_url":"https://api.github.com/users/clarrain/repos","events_url":"https://api.github.com/users/clarrain/events{/privacy}","received_events_url":"https://api.github.com/users/clarrain/received_events","type":"User","site_admin":false},"milestone":null,"comments":12,"created_at":"2016-01-05T21:37:17Z","updated_at":"2016-01-12T20:47:14Z","closed_at":null,"body":"Go through this tutorial:\r\nhttp://www.w3schools.com/sql/"},"comment":{"url":"https://api.github.com/repos/DeveloperLiberationFront/ExploringGHTorrent/issues/comments/171049514","html_url":"https://github.com/DeveloperLiberationFront/ExploringGHTorrent/issues/1#issuecomment-171049514","issue_url":"https://api.github.com/repos/DeveloperLiberationFront/ExploringGHTorrent/issues/1","id":171049514,"user":{"login":"clarrain","id":13869747,"avatar_url":"https://avatars.githubusercontent.com/u/13869747?v=3","gravatar_id":"","url":"https://api.github.com/users/clarrain","html_url":"https://github.com/clarrain","followers_url":"https://api.github.com/users/clarrain/followers","following_url":"https://api.github.com/users/clarrain/following{/other_user}","gists_url":"https://api.github.com/users/clarrain/gists{/gist_id}","starred_url":"https://api.github.com/users/clarrain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/clarrain/subscriptions","organizations_url":"https://api.github.com/users/clarrain/orgs","repos_url":"https://api.github.com/users/clarrain/repos","events_url":"https://api.github.com/users/clarrain/events{/privacy}","received_events_url":"https://api.github.com/users/clarrain/received_events","type":"User","site_admin":false},"created_at":"2016-01-12T20:47:14Z","updated_at":"2016-01-12T20:47:14Z","body":"**Aggregate Function Syntax and Additional Notes**\r\n\r\n#### AVG( )\r\n\r\nSELECT AVG(column_name) FROM table_name;\r\n\r\n#### COUNT( )\r\n\r\nSELECT COUNT(column_name) FROM table_name;\r\n*returns the number of values (NULL values will not be counted) of the specified column*\r\n\r\nSELECT COUNT( * ) FROM table_name;\r\n*returns the number of records in a table*\r\n\r\nSELECT COUNT(DISTINCT column_name) FROM table_name;\r\n*returns the number of distinct values of the specified column*\r\n\r\n#### FIRST( ) & LAST( )\r\n \r\nOnly supported by Microsoft Access. MYSQL workaround: \r\n\r\nSELECT column_name FROM table_name\r\nORDER BY column_name ASC\r\nLIMIT 1;\r\n*returns the first value of the selected column*\r\n\r\nSELECT column_name FROM table_name\r\nORDER BY column_name DESC\r\nLIMIT 1;\r\n*returns the last value of the selected column*\r\n\r\n#### MAX( )\r\n\r\nSELECT MAX(column_name) FROM table_name;\r\n\r\n#### MIN( )\r\n\r\nSELECT MIN(column_name) FROM table_name;\r\n\r\n#### SUM( )\r\n\r\nSELECT SUM(column_name) FROM table_name;"}}