{"action":"closed","issue":{"url":"https://api.github.com/repos/TIY-DC-ROR-2015-Jan/course-notes/issues/108","labels_url":"https://api.github.com/repos/TIY-DC-ROR-2015-Jan/course-notes/issues/108/labels{/name}","comments_url":"https://api.github.com/repos/TIY-DC-ROR-2015-Jan/course-notes/issues/108/comments","events_url":"https://api.github.com/repos/TIY-DC-ROR-2015-Jan/course-notes/issues/108/events","html_url":"https://github.com/TIY-DC-ROR-2015-Jan/course-notes/issues/108","id":57075433,"number":108,"title":"Databasics","user":{"login":"jamesdabbs","id":1079270,"avatar_url":"https://avatars.githubusercontent.com/u/1079270?v=3","gravatar_id":"","url":"https://api.github.com/users/jamesdabbs","html_url":"https://github.com/jamesdabbs","followers_url":"https://api.github.com/users/jamesdabbs/followers","following_url":"https://api.github.com/users/jamesdabbs/following{/other_user}","gists_url":"https://api.github.com/users/jamesdabbs/gists{/gist_id}","starred_url":"https://api.github.com/users/jamesdabbs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamesdabbs/subscriptions","organizations_url":"https://api.github.com/users/jamesdabbs/orgs","repos_url":"https://api.github.com/users/jamesdabbs/repos","events_url":"https://api.github.com/users/jamesdabbs/events{/privacy}","received_events_url":"https://api.github.com/users/jamesdabbs/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TIY-DC-ROR-2015-Jan/course-notes/labels/homework","name":"homework","color":"009800"}],"state":"closed","locked":false,"assignee":{"login":"ablythe","id":6164745,"avatar_url":"https://avatars.githubusercontent.com/u/6164745?v=3","gravatar_id":"","url":"https://api.github.com/users/ablythe","html_url":"https://github.com/ablythe","followers_url":"https://api.github.com/users/ablythe/followers","following_url":"https://api.github.com/users/ablythe/following{/other_user}","gists_url":"https://api.github.com/users/ablythe/gists{/gist_id}","starred_url":"https://api.github.com/users/ablythe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ablythe/subscriptions","organizations_url":"https://api.github.com/users/ablythe/orgs","repos_url":"https://api.github.com/users/ablythe/repos","events_url":"https://api.github.com/users/ablythe/events{/privacy}","received_events_url":"https://api.github.com/users/ablythe/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-02-09T19:12:36Z","updated_at":"2015-02-09T20:47:04Z","closed_at":"2015-02-09T20:47:04Z","body":"_Due on Feb 10 @ 04:00am_\n## Objectives\n\n### Learning Objectives\n\nAfter completing this assignment, you should understand:\n\n* How to connect directly to an SQL database and run queries to manipulate data\n\n### Performance Objectives\n\nAfter completing this assignment, you be able to effectively use\n\n* `select` and `where` to find data\n* `limit` and `offset` to limit results\n* `insert` and `update` to modify data\n* `sum` and aggregation methods\n* `join` to link tables\n\n## Details\n\nYou'll be given an SQLite3 database in class. Connect to it using `sqlite3 <filename>` and explore the following.\n\n### Deliverables\n\nA gist containing answers to the following questions and the command(s) you used to find them.\n\n\n## Normal Mode\n\n* How many users are there?\n* What are the 5 most expensive items?\n* What's the cheapest book?\n* Simulate buying an item by inserting a User for yourself and an Order for that User.\n* Who lives at \"6439 Zetta Hills, Willmouth, WY\"? Do they have another address?\n* Correct Virginie Mitchell's address to \"New York, NY, 10108\".\n* How much would it cost to buy one of each tool?\n* How many total items did we sell?\n* How much was spent on books?\n\n## Hard Mode\n\n* What item was ordered most often? Grossed the most money?\n* What user spent the most?\n* What were the top 3 highest grossing categories?"}}