{"action":"created","issue":{"url":"https://api.github.com/repos/lumodon/pastoral-rhea/issues/2","repository_url":"https://api.github.com/repos/lumodon/pastoral-rhea","labels_url":"https://api.github.com/repos/lumodon/pastoral-rhea/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/lumodon/pastoral-rhea/issues/2/comments","events_url":"https://api.github.com/repos/lumodon/pastoral-rhea/issues/2/events","html_url":"https://github.com/lumodon/pastoral-rhea/issues/2","id":185205355,"number":2,"title":"LeetCode Challenges","user":{"login":"lumodon","id":10302608,"avatar_url":"https://avatars.githubusercontent.com/u/10302608?v=3","gravatar_id":"","url":"https://api.github.com/users/lumodon","html_url":"https://github.com/lumodon","followers_url":"https://api.github.com/users/lumodon/followers","following_url":"https://api.github.com/users/lumodon/following{/other_user}","gists_url":"https://api.github.com/users/lumodon/gists{/gist_id}","starred_url":"https://api.github.com/users/lumodon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lumodon/subscriptions","organizations_url":"https://api.github.com/users/lumodon/orgs","repos_url":"https://api.github.com/users/lumodon/repos","events_url":"https://api.github.com/users/lumodon/events{/privacy}","received_events_url":"https://api.github.com/users/lumodon/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-10-25T19:02:16Z","updated_at":"2016-10-25T22:00:01Z","closed_at":null,"body":"Problem 1: https://leetcode.com/problems/duplicate-emails/\r\nAnswer:\r\n```\r\nCREATE TABLE Person(\r\n\tId INTEGER,\r\n\tEmail VARCHAR(20)\r\n);\r\n\r\nINSERT INTO namedTable (Id, Email) \r\n\tVALUES (1, 'a@b.com'), (2, 'c@d.com'), (3, 'a@b.com');\r\n\t\r\nSELECT * FROM namedTable;\r\n\r\nSELECT DISTINCT Email FROM namedTable x \r\n\tWHERE Email = ANY(\r\n\t\tSELECT Email FROM namedTable y WHERE x.Id != y.Id\r\n\t);\r\n```"},"comment":{"url":"https://api.github.com/repos/lumodon/pastoral-rhea/issues/comments/256189617","html_url":"https://github.com/lumodon/pastoral-rhea/issues/2#issuecomment-256189617","issue_url":"https://api.github.com/repos/lumodon/pastoral-rhea/issues/2","id":256189617,"user":{"login":"sdweber422","id":11862202,"avatar_url":"https://avatars.githubusercontent.com/u/11862202?v=3","gravatar_id":"","url":"https://api.github.com/users/sdweber422","html_url":"https://github.com/sdweber422","followers_url":"https://api.github.com/users/sdweber422/followers","following_url":"https://api.github.com/users/sdweber422/following{/other_user}","gists_url":"https://api.github.com/users/sdweber422/gists{/gist_id}","starred_url":"https://api.github.com/users/sdweber422/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sdweber422/subscriptions","organizations_url":"https://api.github.com/users/sdweber422/orgs","repos_url":"https://api.github.com/users/sdweber422/repos","events_url":"https://api.github.com/users/sdweber422/events{/privacy}","received_events_url":"https://api.github.com/users/sdweber422/received_events","type":"User","site_admin":false},"created_at":"2016-10-25T22:00:01Z","updated_at":"2016-10-25T22:00:01Z","body":"https://leetcode.com/problems/rising-temperature/\r\nANSWER:\r\n```\r\nSELECT w1.Id \r\nFROM Weather w1, Weather w2 \r\nWHERE DATEDIFF(w1.DATE, w2.DATE) = 1 \r\nAND w1.Temperature > w2.Temperature;\r\n```"}}
{"actor":{"display_login":"sdweber422"}}