牛客926165907号

分类

/ 注册

全部文章（共46篇）

题解 | 查找在职员工自入职以来的薪水涨幅情况

with tb1 as( select employees.emp_no, salary from employees join salaries on employees.hire_date = salaries.from_date ), tb2 as( select em...

2025-07-28

0 39

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

select * from( select emp_no, salary, last_name, first_name from employees join salaries using(emp_no) where salary != ( select ma...

2025-07-28

0 44

题解 | 多行输出

str1 = 'Hello World!' str2 = 'Hello Nowcoder!' print(f"{str1}\n{str2}")

2025-07-14

0 35

题解 | 哪些产品在特定时间段内表现最为出色

with tb1 as( select sales_records.product_id, product_name, sales_date, sales_amount, sales_quantity from sales_records left join product...

2025-07-02

0 45

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

with tb1 as( select staff_id, staff_gender, department from staff_tb ), tb2 as( select staff_id, normal_salary - dock_salary as actual_salary ...

2025-06-29

0 48

题解 | 统计每个产品的销售情况

with tb1 as( select orders.product_id, sum(unit_price*quantity) as total_sales, unit_price, sum(quantity) as total_quantity, round(sum(u...

2025-06-29

0 57