{"action":"created","comment":{"url":"https://api.github.com/repos/codebar/tutorials/pulls/comments/241993148","pull_request_review_id":185400803,"id":241993148,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDI0MTk5MzE0OA==","diff_hunk":"@@ -0,0 +1,616 @@\n+---\n+layout: page\n+title: Introduction to SQL\n+---\n+\n+## About Lesson 2\n+\n+_Lesson 2_ will extend your knowledge of the **SELECT** operator by explaining some new operators, ways to sort the results and to **LIMIT** the number of results shown. You'll continue working with an online database already filled in with some data. At the end, you'll find some exercises constructing on top of the lessons 1 and 2.\n+\n+### Ordering query results\n+\n+Normally, when you write a query, you'll want your results to be shown in a specific order. Doing so is very simple knowing the operator **ORDER BY**.\n+This operator is placed at the end of the **SELECT** statement. It's basic syntax is the following:\n+\n+```SQL\n+SELECT {columns}\n+  FROM {table name}\n+ WHERE {conditions}\n+ ORDER BY {expression} {direction};\n+```\n+Where:\n+\n+* **SELECT**, **FROM**, and **WHERE** are the same as in previous lesson,\n+* **{expression}** can be a _column_ name, the _column_ position, a function, or an arithmetic expression,\n+* **{direction}** is either ASC or DESC, if omitted ASC is assumed.\n+\n+Using the same database as in Lesson 1 (https://sqliteonline.com/#fiddle-5be8825d749e251ljod9s39t), run the following query.\n+```SQL\n+SELECT name, age\n+  FROM people\n+ ORDER BY age DESC;\n+```\n+\n+Is the result sorted by descending age? What happen in ages that appear more than once? Are the names sorted?\n+\n+You can add more than one order by pairs of expression and direction:\n+\n+```SQL\n+SELECT name, age\n+  FROM people\n+ ORDER BY age DESC, name ASC;\n+```\n+\n+With the SQL above, in case of equal ages, then records will be sorted by name. Note that each sort has a different direction.\n+\n+The following query is equivalent to the previous one, but instead of using column names, column positions are used.\n+```SQL\n+SELECT name, age\n+  FROM people\n+ ORDER BY 2 DESC, 1 ASC;\n+```\n+\n+This next query is an example of function. The function **LENGTH** in SQLite returns the length of the string passed as parameter (between the parentheses):\n+```SQL\n+SELECT name\n+  FROM people\n+ ORDER BY LENGTH(name) DESC;\n+```\n+\n+Lets now use an arithmetic expression as a last example of sorting:\n+```SQL\n+SELECT name\n+  FROM people\n+ ORDER BY (age + 2 * number_of_children) DESC;\n+```\n+\n+TIP: You can also add expressions and functions in the columns to show in the results: Try this out:\n+```SQL\n+SELECT name, (age + 2 * number_of_children)\n+  FROM people\n+ ORDER BY (age + 2 * number_of_children) DESC;\n+```\n+\n+### Limiting the number of results and paginating\n+\n+When you are building queries that will fill reports, when you are showing the results in pages, or simply when the result is too long, you may want to limit the number of rows you show. To do so, you can use the operator **LIMIT** as follows\n+\n+```SQL\n+SELECT name, age\n+  FROM people\n+ ORDER BY age DESC\n+ LIMIT 5;\n+```\n+\n+Contrary to the query used before without LIMIT that returned all the rows in the table, this one only returns the first 5.\n+\n+Although it is not strictly necessary to have an ORDER BY clause when you LIMIT the results, it is highly recommended. Doing so, you can be certain that you will always get the same results when running the same query multiple times.\n+\n+If additionally you are paginating the result, you need to use LIMIT together with **OFFSET**. This operator can we understood as _Skip the first N records, and give me the ones after_. For example, if you run\n+\n+```SQL\n+SELECT name, age\n+  FROM people\n+ ORDER BY age DESC\n+ LIMIT 5\n+OFFSET 3;\n+```\n+\n+It will ignore the 3 oldest (Mia, Mason and Jacob), and will show the next 5 (Sophia, Benjamin, Abigail, William, and Luis).\n+\n+With LIMIT and OFFSET you can create a pagination mechanism like this:\n+\n+| Page | Query                                                             | Results                                            |\n+| :--: | :---------------------------------------------------------------- | :------------------------------------------------- |\n+| 1    | SELECT name, age FROM people ORDER BY age DESC LIMIT 5 offset 0;  | The first 5 oldest                                 |\n+| 2    | SELECT name, age FROM people ORDER BY age DESC LIMIT 5 offset 5;  | The 6th to the 10th                                |\n+| 3    | SELECT name, age FROM people ORDER BY age DESC LIMIT 5 offset 10; | The 11th to the 12th, as there are no more records |\n+\n+### Filtering with multiple values\n+#### IN operator\n+\n+Sometimes you need to filter some rows of your result and you may end up with queries like the one below\n+\n+```SQL\n+SELECT name\n+  FROM people\n+ WHERE age = 18\n+    OR age = 21\n+    OR age = 30;\n+```\n+\n+This query works, but you can write it in a more readable way, thanks to the operator **IN**\n+```SQL\n+SELECT name\n+  FROM people\n+ WHERE age IN (18,21,30);\n+```\n+\n+Try these two in the database. Do you get the same results? The **IN** operator must be followed by a list of values. All the records having any of the values in the list for the given column (age in this example) will be kept in the result.\n+\n+You can also negate the operator IN, using **NOT IN**. The results is pretty straight forward. Contrary to the IN alone, when using NOT IN, only the record for which their value is NOT in the list will be kept in the result.\n+\n+```SQL\n+SELECT name\n+  FROM people\n+ WHERE age NOT IN (18,21,30);\n+```\n+\n+Try it in the Database. What do you get now?\n+\n+#### LIKE operator\n+\n+Another operator you can use to select multiple records at a time is the operator **LIKE**. This operator is used to filter text columns with partial matches.\n+\n+When using **LIKE**, there are two wildcards you can use in your conditions. Those are:\n+\n+* % - The percent sign represents zero, one, or multiple characters\n+* _ - The underscore represents a single character\n+\n+For example:\n+```SQL\n+SELECT name\n+  FROM people\n+ WHERE name LIKE '%li%';\n+```\n+\n+Will return Olivia Juanes and William Brown. Both have _li_ in them.\n+\n+The following one, will return those starting with _M_:\n+```SQL\n+SELECT *\n+  FROM people\n+ WHERE name LIKE 'M%';\n+```\n+\n+And this one, those ending with _s_:\n+```SQL\n+SELECT *\n+  FROM people\n+ WHERE name LIKE '%s';\n+```\n+\n+If using the _ then this one will return any name where there is an _m_, followed by any character, and then followed by an _r_:\n+```SQL\n+SELECT *\n+  FROM people\n+ WHERE name LIKE '%m_r%';\n+```\n+\n+### The NULL value\n+\n+As defined in [Wikipedia](https://en.wikipedia.org/wiki/Null), **NULL** is a special marker used in SQL to indicate that a data value does not exist in the database. Empty data values lead to a whole subject (_Three valued logic_) that we'll cover in future lessons, but if you are curious you can read more  [here](https://en.wikipedia.org/wiki/Three-valued_logic#Application_in_SQL). For now, we'll just use **IS** and **IS NOT** operators to filter records containing NULL. Two examples below:\n+\n+```SQL\n+SELECT *\n+  FROM people\n+ WHERE studies IS NULL;\n+```\n+\n+```SQL\n+SELECT *\n+  FROM people\n+ WHERE studies IS NOT NULL;\n+```\n+\n+Study the results of each one. Easy huh?\n+\n+It's time to do some exercises now... :)\n+\n+## Lesson 2 exercises\n+\n+For the exercises below, we'll use the table from previous lesson: **people** and we'll introduce four new ones: **locations**, **hosts**, **workshops** and **attendance**. The next sections show a few rows as examples of the values. If you want to see the whole table, you'll find the fiddle link and the SELECT statement under each table.","path":"sql/lesson2/tutorial.md","position":202,"original_position":202,"commit_id":"362d02829efce78be78fa66e01636fb7d12195e1","original_commit_id":"362d02829efce78be78fa66e01636fb7d12195e1","user":{"login":"kodikos","id":3382882,"node_id":"MDQ6VXNlcjMzODI4ODI=","avatar_url":"https://avatars2.githubusercontent.com/u/3382882?v=4","gravatar_id":"","url":"https://api.github.com/users/kodikos","html_url":"https://github.com/kodikos","followers_url":"https://api.github.com/users/kodikos/followers","following_url":"https://api.github.com/users/kodikos/following{/other_user}","gists_url":"https://api.github.com/users/kodikos/gists{/gist_id}","starred_url":"https://api.github.com/users/kodikos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kodikos/subscriptions","organizations_url":"https://api.github.com/users/kodikos/orgs","repos_url":"https://api.github.com/users/kodikos/repos","events_url":"https://api.github.com/users/kodikos/events{/privacy}","received_events_url":"https://api.github.com/users/kodikos/received_events","type":"User","site_admin":false},"body":"A few corrections, if I may:\r\n`For the exercises below, we'll use the **people** table from the previous lesson, and we'll introduce four new tables: **locations**, **hosts**, **workshops** and **attendance**.`\r\nI'm not sure about the value of listing the fields and sample data - we haven't taught them table defs or insert statements, so we should probably just be pointing them straight to the fiddle hashes at the bottom of the tutorial?","created_at":"2018-12-16T19:40:48Z","updated_at":"2018-12-16T19:40:48Z","html_url":"https://github.com/codebar/tutorials/pull/429#discussion_r241993148","pull_request_url":"https://api.github.com/repos/codebar/tutorials/pulls/429","author_association":"NONE","_links":{"self":{"href":"https://api.github.com/repos/codebar/tutorials/pulls/comments/241993148"},"html":{"href":"https://github.com/codebar/tutorials/pull/429#discussion_r241993148"},"pull_request":{"href":"https://api.github.com/repos/codebar/tutorials/pulls/429"}}},"pull_request":{"url":"https://api.github.com/repos/codebar/tutorials/pulls/429","id":238979736,"node_id":"MDExOlB1bGxSZXF1ZXN0MjM4OTc5NzM2","html_url":"https://github.com/codebar/tutorials/pull/429","diff_url":"https://github.com/codebar/tutorials/pull/429.diff","patch_url":"https://github.com/codebar/tutorials/pull/429.patch","issue_url":"https://api.github.com/repos/codebar/tutorials/issues/429","number":429,"state":"open","locked":false,"title":"Sql tutorial - Lessons 1 to 6","user":{"login":"jmbriano","id":22353040,"node_id":"MDQ6VXNlcjIyMzUzMDQw","avatar_url":"https://avatars3.githubusercontent.com/u/22353040?v=4","gravatar_id":"","url":"https://api.github.com/users/jmbriano","html_url":"https://github.com/jmbriano","followers_url":"https://api.github.com/users/jmbriano/followers","following_url":"https://api.github.com/users/jmbriano/following{/other_user}","gists_url":"https://api.github.com/users/jmbriano/gists{/gist_id}","starred_url":"https://api.github.com/users/jmbriano/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmbriano/subscriptions","organizations_url":"https://api.github.com/users/jmbriano/orgs","repos_url":"https://api.github.com/users/jmbriano/repos","events_url":"https://api.github.com/users/jmbriano/events{/privacy}","received_events_url":"https://api.github.com/users/jmbriano/received_events","type":"User","site_admin":false},"body":"This PR is to extend codebar tutorials section with an SQL tutorial.\r\n\r\nThese first 6 lessons are the result of the collaboration of (at least) the following people to whom I'm very thankful for helping me pushing this initiative forward. In chronological order of collaboration: @brunogirin @daverick @kodikos @anufern @MarckK and @leahknight32\r\n\r\nShould we also include in this PR the changes in the main pages to add this new section, please let me know how/where to do it and I'll extend the PR.\r\n\r\nI'm looking forward to hear your feedback ","created_at":"2018-12-16T17:38:30Z","updated_at":"2018-12-16T19:40:48Z","closed_at":null,"merged_at":null,"merge_commit_sha":"a60c8e2d9eb23481a837e70837f0844e94c96ee3","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/codebar/tutorials/pulls/429/commits","review_comments_url":"https://api.github.com/repos/codebar/tutorials/pulls/429/comments","review_comment_url":"https://api.github.com/repos/codebar/tutorials/pulls/comments{/number}","comments_url":"https://api.github.com/repos/codebar/tutorials/issues/429/comments","statuses_url":"https://api.github.com/repos/codebar/tutorials/statuses/362d02829efce78be78fa66e01636fb7d12195e1","head":{"label":"jmbriano:sql-tutorial","ref":"sql-tutorial","sha":"362d02829efce78be78fa66e01636fb7d12195e1","user":{"login":"jmbriano","id":22353040,"node_id":"MDQ6VXNlcjIyMzUzMDQw","avatar_url":"https://avatars3.githubusercontent.com/u/22353040?v=4","gravatar_id":"","url":"https://api.github.com/users/jmbriano","html_url":"https://github.com/jmbriano","followers_url":"https://api.github.com/users/jmbriano/followers","following_url":"https://api.github.com/users/jmbriano/following{/other_user}","gists_url":"https://api.github.com/users/jmbriano/gists{/gist_id}","starred_url":"https://api.github.com/users/jmbriano/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmbriano/subscriptions","organizations_url":"https://api.github.com/users/jmbriano/orgs","repos_url":"https://api.github.com/users/jmbriano/repos","events_url":"https://api.github.com/users/jmbriano/events{/privacy}","received_events_url":"https://api.github.com/users/jmbriano/received_events","type":"User","site_admin":false},"repo":{"id":145025774,"node_id":"MDEwOlJlcG9zaXRvcnkxNDUwMjU3NzQ=","name":"tutorials","full_name":"jmbriano/tutorials","private":false,"owner":{"login":"jmbriano","id":22353040,"node_id":"MDQ6VXNlcjIyMzUzMDQw","avatar_url":"https://avatars3.githubusercontent.com/u/22353040?v=4","gravatar_id":"","url":"https://api.github.com/users/jmbriano","html_url":"https://github.com/jmbriano","followers_url":"https://api.github.com/users/jmbriano/followers","following_url":"https://api.github.com/users/jmbriano/following{/other_user}","gists_url":"https://api.github.com/users/jmbriano/gists{/gist_id}","starred_url":"https://api.github.com/users/jmbriano/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmbriano/subscriptions","organizations_url":"https://api.github.com/users/jmbriano/orgs","repos_url":"https://api.github.com/users/jmbriano/repos","events_url":"https://api.github.com/users/jmbriano/events{/privacy}","received_events_url":"https://api.github.com/users/jmbriano/received_events","type":"User","site_admin":false},"html_url":"https://github.com/jmbriano/tutorials","description":"🗒 codebar's tutorials","fork":true,"url":"https://api.github.com/repos/jmbriano/tutorials","forks_url":"https://api.github.com/repos/jmbriano/tutorials/forks","keys_url":"https://api.github.com/repos/jmbriano/tutorials/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jmbriano/tutorials/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jmbriano/tutorials/teams","hooks_url":"https://api.github.com/repos/jmbriano/tutorials/hooks","issue_events_url":"https://api.github.com/repos/jmbriano/tutorials/issues/events{/number}","events_url":"https://api.github.com/repos/jmbriano/tutorials/events","assignees_url":"https://api.github.com/repos/jmbriano/tutorials/assignees{/user}","branches_url":"https://api.github.com/repos/jmbriano/tutorials/branches{/branch}","tags_url":"https://api.github.com/repos/jmbriano/tutorials/tags","blobs_url":"https://api.github.com/repos/jmbriano/tutorials/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jmbriano/tutorials/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jmbriano/tutorials/git/refs{/sha}","trees_url":"https://api.github.com/repos/jmbriano/tutorials/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jmbriano/tutorials/statuses/{sha}","languages_url":"https://api.github.com/repos/jmbriano/tutorials/languages","stargazers_url":"https://api.github.com/repos/jmbriano/tutorials/stargazers","contributors_url":"https://api.github.com/repos/jmbriano/tutorials/contributors","subscribers_url":"https://api.github.com/repos/jmbriano/tutorials/subscribers","subscription_url":"https://api.github.com/repos/jmbriano/tutorials/subscription","commits_url":"https://api.github.com/repos/jmbriano/tutorials/commits{/sha}","git_commits_url":"https://api.github.com/repos/jmbriano/tutorials/git/commits{/sha}","comments_url":"https://api.github.com/repos/jmbriano/tutorials/comments{/number}","issue_comment_url":"https://api.github.com/repos/jmbriano/tutorials/issues/comments{/number}","contents_url":"https://api.github.com/repos/jmbriano/tutorials/contents/{+path}","compare_url":"https://api.github.com/repos/jmbriano/tutorials/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jmbriano/tutorials/merges","archive_url":"https://api.github.com/repos/jmbriano/tutorials/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jmbriano/tutorials/downloads","issues_url":"https://api.github.com/repos/jmbriano/tutorials/issues{/number}","pulls_url":"https://api.github.com/repos/jmbriano/tutorials/pulls{/number}","milestones_url":"https://api.github.com/repos/jmbriano/tutorials/milestones{/number}","notifications_url":"https://api.github.com/repos/jmbriano/tutorials/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jmbriano/tutorials/labels{/name}","releases_url":"https://api.github.com/repos/jmbriano/tutorials/releases{/id}","deployments_url":"https://api.github.com/repos/jmbriano/tutorials/deployments","created_at":"2018-08-16T18:35:27Z","updated_at":"2018-10-09T19:47:20Z","pushed_at":"2018-12-16T17:21:59Z","git_url":"git://github.com/jmbriano/tutorials.git","ssh_url":"git@github.com:jmbriano/tutorials.git","clone_url":"https://github.com/jmbriano/tutorials.git","svn_url":"https://github.com/jmbriano/tutorials","homepage":"http://tutorials.codebar.io/","size":42436,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":5,"mirror_url":null,"archived":false,"open_issues_count":1,"license":null,"forks":5,"open_issues":1,"watchers":0,"default_branch":"gh-pages"}},"base":{"label":"codebar:gh-pages","ref":"gh-pages","sha":"35b3ccbd718a36993e5d3a4fd3060564fef6cada","user":{"login":"codebar","id":5642384,"node_id":"MDEyOk9yZ2FuaXphdGlvbjU2NDIzODQ=","avatar_url":"https://avatars3.githubusercontent.com/u/5642384?v=4","gravatar_id":"","url":"https://api.github.com/users/codebar","html_url":"https://github.com/codebar","followers_url":"https://api.github.com/users/codebar/followers","following_url":"https://api.github.com/users/codebar/following{/other_user}","gists_url":"https://api.github.com/users/codebar/gists{/gist_id}","starred_url":"https://api.github.com/users/codebar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codebar/subscriptions","organizations_url":"https://api.github.com/users/codebar/orgs","repos_url":"https://api.github.com/users/codebar/repos","events_url":"https://api.github.com/users/codebar/events{/privacy}","received_events_url":"https://api.github.com/users/codebar/received_events","type":"Organization","site_admin":false},"repo":{"id":13788016,"node_id":"MDEwOlJlcG9zaXRvcnkxMzc4ODAxNg==","name":"tutorials","full_name":"codebar/tutorials","private":false,"owner":{"login":"codebar","id":5642384,"node_id":"MDEyOk9yZ2FuaXphdGlvbjU2NDIzODQ=","avatar_url":"https://avatars3.githubusercontent.com/u/5642384?v=4","gravatar_id":"","url":"https://api.github.com/users/codebar","html_url":"https://github.com/codebar","followers_url":"https://api.github.com/users/codebar/followers","following_url":"https://api.github.com/users/codebar/following{/other_user}","gists_url":"https://api.github.com/users/codebar/gists{/gist_id}","starred_url":"https://api.github.com/users/codebar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codebar/subscriptions","organizations_url":"https://api.github.com/users/codebar/orgs","repos_url":"https://api.github.com/users/codebar/repos","events_url":"https://api.github.com/users/codebar/events{/privacy}","received_events_url":"https://api.github.com/users/codebar/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/codebar/tutorials","description":"🗒 codebar's tutorials","fork":false,"url":"https://api.github.com/repos/codebar/tutorials","forks_url":"https://api.github.com/repos/codebar/tutorials/forks","keys_url":"https://api.github.com/repos/codebar/tutorials/keys{/key_id}","collaborators_url":"https://api.github.com/repos/codebar/tutorials/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/codebar/tutorials/teams","hooks_url":"https://api.github.com/repos/codebar/tutorials/hooks","issue_events_url":"https://api.github.com/repos/codebar/tutorials/issues/events{/number}","events_url":"https://api.github.com/repos/codebar/tutorials/events","assignees_url":"https://api.github.com/repos/codebar/tutorials/assignees{/user}","branches_url":"https://api.github.com/repos/codebar/tutorials/branches{/branch}","tags_url":"https://api.github.com/repos/codebar/tutorials/tags","blobs_url":"https://api.github.com/repos/codebar/tutorials/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/codebar/tutorials/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/codebar/tutorials/git/refs{/sha}","trees_url":"https://api.github.com/repos/codebar/tutorials/git/trees{/sha}","statuses_url":"https://api.github.com/repos/codebar/tutorials/statuses/{sha}","languages_url":"https://api.github.com/repos/codebar/tutorials/languages","stargazers_url":"https://api.github.com/repos/codebar/tutorials/stargazers","contributors_url":"https://api.github.com/repos/codebar/tutorials/contributors","subscribers_url":"https://api.github.com/repos/codebar/tutorials/subscribers","subscription_url":"https://api.github.com/repos/codebar/tutorials/subscription","commits_url":"https://api.github.com/repos/codebar/tutorials/commits{/sha}","git_commits_url":"https://api.github.com/repos/codebar/tutorials/git/commits{/sha}","comments_url":"https://api.github.com/repos/codebar/tutorials/comments{/number}","issue_comment_url":"https://api.github.com/repos/codebar/tutorials/issues/comments{/number}","contents_url":"https://api.github.com/repos/codebar/tutorials/contents/{+path}","compare_url":"https://api.github.com/repos/codebar/tutorials/compare/{base}...{head}","merges_url":"https://api.github.com/repos/codebar/tutorials/merges","archive_url":"https://api.github.com/repos/codebar/tutorials/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/codebar/tutorials/downloads","issues_url":"https://api.github.com/repos/codebar/tutorials/issues{/number}","pulls_url":"https://api.github.com/repos/codebar/tutorials/pulls{/number}","milestones_url":"https://api.github.com/repos/codebar/tutorials/milestones{/number}","notifications_url":"https://api.github.com/repos/codebar/tutorials/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/codebar/tutorials/labels{/name}","releases_url":"https://api.github.com/repos/codebar/tutorials/releases{/id}","deployments_url":"https://api.github.com/repos/codebar/tutorials/deployments","created_at":"2013-10-22T22:48:27Z","updated_at":"2018-12-05T23:17:35Z","pushed_at":"2018-12-16T17:38:31Z","git_url":"git://github.com/codebar/tutorials.git","ssh_url":"git@github.com:codebar/tutorials.git","clone_url":"https://github.com/codebar/tutorials.git","svn_url":"https://github.com/codebar/tutorials","homepage":"http://tutorials.codebar.io/","size":43233,"stargazers_count":185,"watchers_count":185,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":216,"mirror_url":null,"archived":false,"open_issues_count":36,"license":null,"forks":216,"open_issues":36,"watchers":185,"default_branch":"gh-pages"}},"_links":{"self":{"href":"https://api.github.com/repos/codebar/tutorials/pulls/429"},"html":{"href":"https://github.com/codebar/tutorials/pull/429"},"issue":{"href":"https://api.github.com/repos/codebar/tutorials/issues/429"},"comments":{"href":"https://api.github.com/repos/codebar/tutorials/issues/429/comments"},"review_comments":{"href":"https://api.github.com/repos/codebar/tutorials/pulls/429/comments"},"review_comment":{"href":"https://api.github.com/repos/codebar/tutorials/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/codebar/tutorials/pulls/429/commits"},"statuses":{"href":"https://api.github.com/repos/codebar/tutorials/statuses/362d02829efce78be78fa66e01636fb7d12195e1"}},"author_association":"NONE"}}
{"actor":{"display_login":"kodikos"}}