{"push_id":1044419956,"size":1,"distinct_size":1,"ref":"refs/heads/master","head":"66e31bc5f3d9faa35e9b1b523625351e9133d16b","before":"d673fe1c17241bbca7b7a48d7d35b24fb2b8a257","commits":[{"sha":"66e31bc5f3d9faa35e9b1b523625351e9133d16b","author":{"email":"2b2804ed800b9cdb3a1fd59e491afccf605e4939@gmail.com","name":"njxjtu"},"message":"Create caseStatment.sql\n\nThis is a simple example demonstrating how case statement can be used in where clause of a select query.\r\n\r\nThe  logic is when subject is not specified(null) in repeatable course table, it means all the courses with certain course number are repeatable; whereas when course number is not specified(null), all the courses with the given subject are repeatable. If both subject and course number are null, that means all courses are repeatable.","distinct":true,"url":"https://api.github.com/repos/njxjtu/Oracle_CaseStatmentInSelectQuery/commits/66e31bc5f3d9faa35e9b1b523625351e9133d16b"}]}