摘要: There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For example, the tab 阅读全文
posted @ 2017-09-13 19:34 Pickle 阅读(346) 评论(0) 推荐(0) 编辑
摘要: X city opened a new cinema, many people would like to go to this cinema. The cinema also gives out a poster indicating the movies’ ratings and descrip 阅读全文
posted @ 2017-09-13 18:49 Pickle 阅读(294) 评论(0) 推荐(0) 编辑
摘要: Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice ver 阅读全文
posted @ 2017-09-13 18:42 Pickle 阅读(350) 评论(0) 推荐(0) 编辑