LeetCode_SQL_Easy
什么你竟然不会敲代码
因故停了,谢谢大家支持。不必私信
展开
-
LeetCode-SQL-[Easy]1179. 重新格式化部门表
Create table If Not Exists Department (id int, revenue int, month varchar(5))Truncate table Departmentinsert into Department (id, revenue, month) values ('1', '8000', 'Jan')insert into Department ...原创 2020-03-29 10:31:30 · 221 阅读 · 0 评论 -
LeetCode-SQL-[Easy][水题]627. 交换工资
create table if not exists salary(id int, name varchar(100), sex char(1), salary int)Truncate table salaryinsert into salary (id, name, sex, salary) values ('1', 'A', 'm', '2500')insert into salar...原创 2020-03-29 10:26:29 · 195 阅读 · 0 评论 -
LeetCode-SQL-[Easy][水题]620. 有趣的电影
Create table If Not Exists cinema (id int, movie varchar(255), description varchar(255), rating float(2, 1))Truncate table cinemainsert into cinema (id, movie, description, rating) values ('1', 'Wa...原创 2020-03-29 10:18:28 · 206 阅读 · 0 评论 -
LeetCode-SQL-[Easy][水题]596. 超过5名学生的课
select class from coursesgroup by classhaving count(distinct student)>=5原创 2020-03-28 12:05:04 · 206 阅读 · 0 评论 -
LeetCode-SQL-[Easy][水题]595. 大的国家
SELECT name, population, area FROM worldWHERE area > 3000000 OR population > 25000000原创 2020-03-28 11:59:19 · 219 阅读 · 0 评论 -
LeetCode-SQL-[Easy]1350. 院系无效的学生
Create table If Not Exists Departments (id int, name varchar(30))Create table If Not Exists Students (id int, name varchar(30), department_id int)Truncate table Departmentsinsert into Departments ...原创 2020-03-28 09:31:49 · 314 阅读 · 0 评论