09 2017 档案
摘要：The Employee table holds all employees. Every employee has an Id, and there is also a column for the department Id. The Department table holds all dep
阅读全文
摘要：X city built a new stadium, each day many people visit it and the stats are saved as these columns: id, date, people Please write a query to display t
阅读全文
摘要：Mary is a teacher in a middle school and she has a table seat storing students' names and their corresponding seat ids. The column id is continuous in
阅读全文
摘要：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
阅读全文
摘要：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
阅读全文
摘要：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
阅读全文
摘要：You are given two non-empty linked lists representing two non-negative integers. The digits are stored in reverse order and each of their nodes contai
阅读全文
摘要：You are given two non-empty linked lists representing two non-negative integers. The most significant digit comes first and each of their nodes contai
阅读全文
摘要：Given an m * n matrix M initialized with all 0's and several update operations. Operations are represented by a 2D array, and each operation is repres
阅读全文
