{"action":"opened","issue":{"url":"https://api.github.com/repos/jamesraylittle/DatabaseProject/issues/2","labels_url":"https://api.github.com/repos/jamesraylittle/DatabaseProject/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/jamesraylittle/DatabaseProject/issues/2/comments","events_url":"https://api.github.com/repos/jamesraylittle/DatabaseProject/issues/2/events","html_url":"https://github.com/jamesraylittle/DatabaseProject/issues/2","id":73498194,"number":2,"title":"Part 3 Section B Needs to be implemented","user":{"login":"jamesraylittle","id":6274569,"avatar_url":"https://avatars.githubusercontent.com/u/6274569?v=3","gravatar_id":"","url":"https://api.github.com/users/jamesraylittle","html_url":"https://github.com/jamesraylittle","followers_url":"https://api.github.com/users/jamesraylittle/followers","following_url":"https://api.github.com/users/jamesraylittle/following{/other_user}","gists_url":"https://api.github.com/users/jamesraylittle/gists{/gist_id}","starred_url":"https://api.github.com/users/jamesraylittle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamesraylittle/subscriptions","organizations_url":"https://api.github.com/users/jamesraylittle/orgs","repos_url":"https://api.github.com/users/jamesraylittle/repos","events_url":"https://api.github.com/users/jamesraylittle/events{/privacy}","received_events_url":"https://api.github.com/users/jamesraylittle/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-05-06T03:07:16Z","updated_at":"2015-05-06T03:07:16Z","closed_at":null,"body":"Part 3 Section B of the project needs to be implemented.\r\n\r\nThe problem as stated:\r\n\r\nFor a given N show a table that contains foreach instructor:\r\n * ratio between the total number of TA hours and the total enrollment of all undergraduate\r\n    \r\n       (total TA hours for course / total enrolled for a course)\r\n       course being undergraduate course, $level[0] < 5, or\r\n       course level < 5000, example: 1441 is a undergrate course, 5334 is not.\r\n * perform the above ratio for graduate courses\r\n * N is for the past year; the sql may look simiar to (in the WHERE clause)\r\n         ... WHERE ( (year >= YEAR(CURDATE()) - $n) AND year <= YEAR(CURDATE()) ) ...\r\n\r\n* number of all distinct courses\r\n* the number of courses taught in the past N years (not just distinct courses)\r\n* total number of graduate coureses in N years.\r\n\r\n"}}