海纳冰川，人纳天下，龙纳万物

分类

题解(9)

/ 注册

全部文章（共29篇）

题解 | #用列表实现队列#

import sysstack=[1,2,3,4,5]stack.pop(0)print(stack)stack.pop(0)print(stack)stack.append(int(input()))print(stack)

2024-09-02

0 69

题解 | #密码游戏#

import sys s=input() last=[] for i in s: last.append((int(i)+3)%9) middle=last[0] last[0]=last[2] last[2]=middle middle=last[1] last[1]=last[3]...

2024-09-02

0 70

题解 | #高级操作符练习(2）#

select device_id,gender,age,university,gpa from user_profile where university='北京大学' or gpa>3.7

2022-11-07

0 149

题解 | #高级操作符练习(1)#

select device_id,gender,age,university,gpa from user_profile where gender='male' and gpa>3.5

2022-11-07

0 211

题解 | #牛客的课程订单分析(二)#

SELECT * from order_infowhere status='completed' and product_name in('java','C++','PYTHON')and date>'2025-10-15' and user_id in(SELECT user_id fr...

2021-07-20

0 453

题解 | #牛客的课程订单分析(二)#

SELECT user_id from order_infowhere status='completed' and product_name in('java','C++','PYTHON')and date>'2025-10-15'GROUP by user_idHAVING COUNT...

2021-07-20

0 360

题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#

select emp_no,salary from salariesorder by salary desc limit 1 offset 1 select emp_no,salary from salariesorder by salary desc limit 1,1

2021-06-20

0 450

题解 | #查找当前薪水详情以及部门编号dept_no#

一个多表连接案例select dept_manager.emp_no,salary,from_date,dept_manager.to_date,dept_no from salaries, dept_manager where salaries.emp_no=dept_manager....

2021-06-19

2 425

题解 | #查找最晚入职员工的所有信息#

select * from employees where hire_date like (select hire_date from employees &nbs...

2021-06-19

2 344