wzying

分类

/ 注册

全部文章（共34篇）

题解 | #刷题通过的题目排名#

select id,number, dense_rank() over(order by number desc) t_rank from passing_number ;

2023-03-28

0 192

让AI写| #将所有获取奖金的员工当前的薪水增加10%#

UPDATE salaries SET salary = salary * 1.1 WHERE emp_no IN (SELECT emp_no FROM emp_bonus) AND to_date = '9999-01-01';

2023-03-28

0 179

让ai来写#牛客的课程订单分析(六)#

SELECT o.id, o.is_group_buy, IF(o.is_group_buy = 'Yes', NULL, c.name) AS client_name FROM order_info o left JOIN client c ON o.cli...

2023-03-28

0 272

题解 | #实习广场投递简历分析(二)#

select job,DATE_FORMAT(date,'%Y-%m') mon ,sum(num) cnt from resume_info where date like '2025%' group by job,mon order by mon desc,cnt desc ;

2023-03-28

0 190

题解 | #最差是第几名(一)#

select grade, case when grade='A' then (select sum(a.number) from (select * from class_grade order by grade limit 1) a) when grade='B' then (select...

2023-03-28

1 301

题解 | #考试分数(二)#

select a.id,a.job,a.score from grade a join (select job,avg(score) avg_score from grade group by job) b on a.job=b.job where a.score>b.avg_score o...

2023-03-27

1 252

题解 | #平均工资#

select avg(salary) from salaries where to_date = '9999-01-01' and salary<> (select max(salary) from salaries where to_date = '9999-01-01' ) an...

2023-03-27

0 215

题解 | #按照dept_no进行汇总#

select dept_no,group_concat(emp_no) from dept_emp group by dept_no;

2023-03-27

0 242

题解 | #获取employees中的first_name#

select t1.first_name from ( select first_name from employees order by RIGHT(first_name,1) ) t1 order by RIGHT(t1.first_name,2) ;

2023-03-27

0 192

题解 | #创建唯一索引#

CREATE UNIQUE INDEX uniq_idx_firstname on actor(first_name); CREATE INDEX idx_lastname ON actor(last_name); ALTER TABLE actor ADD INDEX idx_lastname ...

2023-03-26

0 273