{"action":"created","comment":{"url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/comments/100541165","pull_request_review_id":21253229,"id":100541165,"diff_hunk":"@@ -5,24 +5,44 @@ CREATE DATABASE \"sql-diagnostic\";\n \n -- Question 1. Create a table called `licensees` to hold data in columns surname, given_name, gender, height, weight, born_on, eye_color, hair_color.  See `data/licensees.csv` for example data.  Don't forget that all tables should have an id column as a unique identifier for a row.\n \n--- your code here\n+CREATE TABLE licensees (\n+  id SERIAL PRIMARY KEY,\n+  surname TEXT,\n+  given_name TEXT,\n+  gender TEXT,\n+  height INTEGER,\n+  weight INTEGER,\n+  born_on DATE,\n+  eye_color TEXT,\n+  hair_color TEXT\n+);\n \n -- Question 2. Add `Bishop, Caren, f, 63, 132, 1943-09-26, Brown, Black` into the table of licensees.\n \n--- your code here\n-\n+INSERT INTO licensees(surname, given_name, gender, height, weight, born_on, eye_color, hair_color)\n+  SELECT 'Bishop', 'Caren', 'f', 63, 132, '1943-09-26', 'Brown', 'Black'\n+;\n -- After completing questions 1 and 2 uncomment the following to load data from `data/licensees.csv` into the `licensees` table.\n \n--- \\copy licensees(surname,given_name,gender,height,weight,born_on,eye_color,hair_color) FROM './data/licensees.csv' WITH (FORMAT csv, HEADER true)\n+\\copy licensees(surname,given_name,gender,height,weight,born_on,eye_color,hair_color) FROM './data/licensees.csv' WITH (FORMAT csv, HEADER true)\n \n -- Question 3. Write a query to get all attributes of licensees with Hazel eye color and Brown or Black hair color.\n \n--- your code here\n+SELECT","path":"diagnostic.sql","position":32,"original_position":32,"commit_id":"4b6ba1763037df5a60e054792aa3dba78132b437","original_commit_id":"4b6ba1763037df5a60e054792aa3dba78132b437","user":{"login":"bernardlee","id":12991284,"avatar_url":"https://avatars.githubusercontent.com/u/12991284?v=3","gravatar_id":"","url":"https://api.github.com/users/bernardlee","html_url":"https://github.com/bernardlee","followers_url":"https://api.github.com/users/bernardlee/followers","following_url":"https://api.github.com/users/bernardlee/following{/other_user}","gists_url":"https://api.github.com/users/bernardlee/gists{/gist_id}","starred_url":"https://api.github.com/users/bernardlee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bernardlee/subscriptions","organizations_url":"https://api.github.com/users/bernardlee/orgs","repos_url":"https://api.github.com/users/bernardlee/repos","events_url":"https://api.github.com/users/bernardlee/events{/privacy}","received_events_url":"https://api.github.com/users/bernardlee/received_events","type":"User","site_admin":false},"body":"`SELECT FROM licensees` won't yield any results.","created_at":"2017-02-10T14:12:30Z","updated_at":"2017-02-10T14:12:30Z","html_url":"https://github.com/ga-wdi-boston/sql-diagnostic/pull/162#discussion_r100541165","pull_request_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/162","_links":{"self":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/comments/100541165"},"html":{"href":"https://github.com/ga-wdi-boston/sql-diagnostic/pull/162#discussion_r100541165"},"pull_request":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/162"}}},"pull_request":{"url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/162","id":105015562,"html_url":"https://github.com/ga-wdi-boston/sql-diagnostic/pull/162","diff_url":"https://github.com/ga-wdi-boston/sql-diagnostic/pull/162.diff","patch_url":"https://github.com/ga-wdi-boston/sql-diagnostic/pull/162.patch","issue_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/issues/162","number":162,"state":"open","locked":false,"title":"SQL diagnostic","user":{"login":"laurpaik","id":23316584,"avatar_url":"https://avatars.githubusercontent.com/u/23316584?v=3","gravatar_id":"","url":"https://api.github.com/users/laurpaik","html_url":"https://github.com/laurpaik","followers_url":"https://api.github.com/users/laurpaik/followers","following_url":"https://api.github.com/users/laurpaik/following{/other_user}","gists_url":"https://api.github.com/users/laurpaik/gists{/gist_id}","starred_url":"https://api.github.com/users/laurpaik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laurpaik/subscriptions","organizations_url":"https://api.github.com/users/laurpaik/orgs","repos_url":"https://api.github.com/users/laurpaik/repos","events_url":"https://api.github.com/users/laurpaik/events{/privacy}","received_events_url":"https://api.github.com/users/laurpaik/received_events","type":"User","site_admin":false},"body":"comfort: 3.5\r\nclarity: 4","created_at":"2017-02-07T14:26:21Z","updated_at":"2017-02-10T14:12:30Z","closed_at":null,"merged_at":null,"merge_commit_sha":"ed7e845b6194fdf99ee42e5e07f6c1b878968659","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/162/commits","review_comments_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/162/comments","review_comment_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/comments{/number}","comments_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/issues/162/comments","statuses_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/statuses/4b6ba1763037df5a60e054792aa3dba78132b437","head":{"label":"laurpaik:response","ref":"response","sha":"4b6ba1763037df5a60e054792aa3dba78132b437","user":{"login":"laurpaik","id":23316584,"avatar_url":"https://avatars.githubusercontent.com/u/23316584?v=3","gravatar_id":"","url":"https://api.github.com/users/laurpaik","html_url":"https://github.com/laurpaik","followers_url":"https://api.github.com/users/laurpaik/followers","following_url":"https://api.github.com/users/laurpaik/following{/other_user}","gists_url":"https://api.github.com/users/laurpaik/gists{/gist_id}","starred_url":"https://api.github.com/users/laurpaik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laurpaik/subscriptions","organizations_url":"https://api.github.com/users/laurpaik/orgs","repos_url":"https://api.github.com/users/laurpaik/repos","events_url":"https://api.github.com/users/laurpaik/events{/privacy}","received_events_url":"https://api.github.com/users/laurpaik/received_events","type":"User","site_admin":false},"repo":{"id":81214024,"name":"sql-diagnostic","full_name":"laurpaik/sql-diagnostic","owner":{"login":"laurpaik","id":23316584,"avatar_url":"https://avatars.githubusercontent.com/u/23316584?v=3","gravatar_id":"","url":"https://api.github.com/users/laurpaik","html_url":"https://github.com/laurpaik","followers_url":"https://api.github.com/users/laurpaik/followers","following_url":"https://api.github.com/users/laurpaik/following{/other_user}","gists_url":"https://api.github.com/users/laurpaik/gists{/gist_id}","starred_url":"https://api.github.com/users/laurpaik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laurpaik/subscriptions","organizations_url":"https://api.github.com/users/laurpaik/orgs","repos_url":"https://api.github.com/users/laurpaik/repos","events_url":"https://api.github.com/users/laurpaik/events{/privacy}","received_events_url":"https://api.github.com/users/laurpaik/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/laurpaik/sql-diagnostic","description":"Assessment for \"An introduction to relational databases\"","fork":true,"url":"https://api.github.com/repos/laurpaik/sql-diagnostic","forks_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/forks","keys_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/keys{/key_id}","collaborators_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/teams","hooks_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/hooks","issue_events_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/issues/events{/number}","events_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/events","assignees_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/assignees{/user}","branches_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/branches{/branch}","tags_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/tags","blobs_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/git/refs{/sha}","trees_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/git/trees{/sha}","statuses_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/statuses/{sha}","languages_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/languages","stargazers_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/stargazers","contributors_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/contributors","subscribers_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/subscribers","subscription_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/subscription","commits_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/commits{/sha}","git_commits_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/git/commits{/sha}","comments_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/comments{/number}","issue_comment_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/issues/comments{/number}","contents_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/contents/{+path}","compare_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/compare/{base}...{head}","merges_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/merges","archive_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/downloads","issues_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/issues{/number}","pulls_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/pulls{/number}","milestones_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/milestones{/number}","notifications_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/labels{/name}","releases_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/releases{/id}","deployments_url":"https://api.github.com/repos/laurpaik/sql-diagnostic/deployments","created_at":"2017-02-07T14:00:26Z","updated_at":"2016-11-12T18:06:45Z","pushed_at":"2017-02-07T14:25:59Z","git_url":"git://github.com/laurpaik/sql-diagnostic.git","ssh_url":"git@github.com:laurpaik/sql-diagnostic.git","clone_url":"https://github.com/laurpaik/sql-diagnostic.git","svn_url":"https://github.com/laurpaik/sql-diagnostic","homepage":null,"size":31,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"ga-wdi-boston:master","ref":"master","sha":"ee85afe41d2d7abfdda68436714c46e173b0aa81","user":{"login":"ga-wdi-boston","id":6361298,"avatar_url":"https://avatars.githubusercontent.com/u/6361298?v=3","gravatar_id":"","url":"https://api.github.com/users/ga-wdi-boston","html_url":"https://github.com/ga-wdi-boston","followers_url":"https://api.github.com/users/ga-wdi-boston/followers","following_url":"https://api.github.com/users/ga-wdi-boston/following{/other_user}","gists_url":"https://api.github.com/users/ga-wdi-boston/gists{/gist_id}","starred_url":"https://api.github.com/users/ga-wdi-boston/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ga-wdi-boston/subscriptions","organizations_url":"https://api.github.com/users/ga-wdi-boston/orgs","repos_url":"https://api.github.com/users/ga-wdi-boston/repos","events_url":"https://api.github.com/users/ga-wdi-boston/events{/privacy}","received_events_url":"https://api.github.com/users/ga-wdi-boston/received_events","type":"Organization","site_admin":false},"repo":{"id":39354921,"name":"sql-diagnostic","full_name":"ga-wdi-boston/sql-diagnostic","owner":{"login":"ga-wdi-boston","id":6361298,"avatar_url":"https://avatars.githubusercontent.com/u/6361298?v=3","gravatar_id":"","url":"https://api.github.com/users/ga-wdi-boston","html_url":"https://github.com/ga-wdi-boston","followers_url":"https://api.github.com/users/ga-wdi-boston/followers","following_url":"https://api.github.com/users/ga-wdi-boston/following{/other_user}","gists_url":"https://api.github.com/users/ga-wdi-boston/gists{/gist_id}","starred_url":"https://api.github.com/users/ga-wdi-boston/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ga-wdi-boston/subscriptions","organizations_url":"https://api.github.com/users/ga-wdi-boston/orgs","repos_url":"https://api.github.com/users/ga-wdi-boston/repos","events_url":"https://api.github.com/users/ga-wdi-boston/events{/privacy}","received_events_url":"https://api.github.com/users/ga-wdi-boston/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ga-wdi-boston/sql-diagnostic","description":"Assessment for \"An introduction to relational databases\"","fork":false,"url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic","forks_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/forks","keys_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/teams","hooks_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/hooks","issue_events_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/issues/events{/number}","events_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/events","assignees_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/assignees{/user}","branches_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/branches{/branch}","tags_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/tags","blobs_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/git/refs{/sha}","trees_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/statuses/{sha}","languages_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/languages","stargazers_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/stargazers","contributors_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/contributors","subscribers_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/subscribers","subscription_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/subscription","commits_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/commits{/sha}","git_commits_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/git/commits{/sha}","comments_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/comments{/number}","issue_comment_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/issues/comments{/number}","contents_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/contents/{+path}","compare_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/merges","archive_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/downloads","issues_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/issues{/number}","pulls_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls{/number}","milestones_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/milestones{/number}","notifications_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/labels{/name}","releases_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/releases{/id}","deployments_url":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/deployments","created_at":"2015-07-20T00:36:18Z","updated_at":"2016-11-12T18:06:45Z","pushed_at":"2017-02-07T14:40:06Z","git_url":"git://github.com/ga-wdi-boston/sql-diagnostic.git","ssh_url":"git@github.com:ga-wdi-boston/sql-diagnostic.git","clone_url":"https://github.com/ga-wdi-boston/sql-diagnostic.git","svn_url":"https://github.com/ga-wdi-boston/sql-diagnostic","homepage":null,"size":31,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":160,"mirror_url":null,"open_issues_count":21,"forks":160,"open_issues":21,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/162"},"html":{"href":"https://github.com/ga-wdi-boston/sql-diagnostic/pull/162"},"issue":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/issues/162"},"comments":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/issues/162/comments"},"review_comments":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/162/comments"},"review_comment":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/pulls/162/commits"},"statuses":{"href":"https://api.github.com/repos/ga-wdi-boston/sql-diagnostic/statuses/4b6ba1763037df5a60e054792aa3dba78132b437"}}}}
{"actor":{"display_login":"bernardlee"}}