酱饼

SQL91获得积分最多的人(三) select a.user_id, u.name, a.grade_sumfrom(select user_id, sum(if(type=...

酱饼

SQL86实习广场投递简历分析(三) select a.job, first_year_mon, first_year_cnt, second_year_mon, secon...

酱饼

SQL81牛客的课程订单分析(五) select a.user_id, min(case when a.`rank`=1 then date end) as firs...

酱饼

SQL76考试分数(五) select id, job, score, `t_rank`from(select id, job, score,row_number() ove...

酱饼

SQL71牛客每个人最近的登录日期(六) select distinct u.name, pn.date, sum(pn.number) over(partition by ...

酱饼

SQL66牛客每个人最近的登录日期(一) select user_id, max(date) as idfrom logingroup by user_idorder by ...

酱饼

SQL61 给出employees表中排名为奇数行的first_name select first_namefrom (select emp_no, first_name ,...

酱饼

SQL57使用含有关键字exists查找未分配具体部门的员工的所有信息。 select e.* from employees e where not exists(selec...

酱饼

SQL51查找字符串中逗号出现的次数 select id,length(string) - length(replace(string,',','')) from strin...

酱饼

SQL46在audit表上创建外键约束，其emp_no对应employees_test表的主键id alter table audit add foreign key(emp...

酱饼

SQL41构造一个触发器audit_log CREATE TRIGGER audit_log AFTER insertON employees_test FOR EACH R...

酱饼

SQL36创建一个actor_name表 create table actor_name as select first_name,last_name from actor ...

酱饼

SQL32将employees表的所有员工的last_name和first_name拼接起来作为Name select concat(last_name,' ',fir...

酱饼

SQL26汇总各个部门当前员工的title类型的分配数目 select de.dept_no, d.dept_name, t.title, coun...

酱饼

SQL21 查找在职员工自入职以来的薪水涨幅情况 select a.emp_no, (a.salary - b.salary) growthfrom (...

酱饼

SQL16统计出当前各个title类型对应的员工当前薪水对应的平均工资 select t.title,avg(s.salary) as sa from titles t jo...

酱饼

SQL11获取所有员工当前的manager select de.emp_no As emp_no, dm.emp_no AS manager from dept_emp de...

酱饼

SQL7查找薪水记录超过15条的员工号emp_no以及其对应的记录次数t select emp_no,t from (select emp_no,count(salary) ...

酱饼

牛客网的SQL实战模块： https://www.nowcoder.com/ta/sql?page=0 SQL1查找最晚入职员工的所有信息 select * from emp...