Qadccccc

分类

题解(12)

/ 注册

全部文章（共116篇）

题解 | #最小#

-- select job|avg(1.0*score) from grade group by job ; select job , round((1.0*sum(score)/count(id) ),3) as a from grade group by job ord...

Mysql

2022-02-06

1 360

题解 | #SQL5# 左连接

select e.last_name,e.first_name,d.dept_no from employees e left join dept_emp d on e.emp_no =d.emp_no

Mysql

2021-10-06

1 372

题解 SQ3

-- select job|avg(1.0*score) from grade group by job ; select job , round((1.0*sum(score)/count(id) ),3) as a from grade group by job ord...

Mysql

2021-10-06

0 399

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

-- select job|avg(1.0*score) from grade group by job ; select job , round((1.0*sum(score)/count(id) ),3) as a from grade group by job ord...

Mysql

2021-10-02

0 403

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

先按照job 分组然后统计每个分组的求和除以统计个数、然后保留小数3位。再按照平均分排序 -- select job|avg(1.0*score) from grade group by job ; select job , round((1.0*sum(score)/c...

Mysql

2021-10-02

0 386

CD101题：单调栈结构

题目链接https://www.nowcoder.com/ta/programmer-code-interview-guide // 1. 定义两个数组Left[] 保存左边小值。 Right保存右边小值。// 2. 定义Stack 保存单调递增的下标值。// 3.循环遍历整个数组//栈为空入栈[...

2020-11-08

0 666