牛客251960512号

分类

markdown(1) MySQL(15) numpy(3) Obsidian(6) pandas(6) PPT(1) Pyhon面向对象(1) Python基础语法(60) Python数据分析与展示(11) python自动化(2) Tableau(17) 可视化(3) 未归档(1) 百度(1) 系统(1) 系统问题(1) 题解(40)

/ 注册

全部文章（共163篇）

题解 | #获取所有非manager员工当前的薪水情况#

方法1 select de.dept_no, e.emp_no, s.salary from employees e join dept_emp de on e.emp_no = de.emp_no join salaries s on e.emp_no = s.emp_no left join ...

Mysql

2021-10-28

0 342

题解 | #获取有奖金的员工相关信息。#

select e.emp_no,e.first_name, e.last_name, eb.btype,s.salary , case when eb.btype =1 then s.salary*0.1 when eb.btype =2 then s.salary*0.2 e...

Mysql

2021-10-28

0 367

题解 | #统计各个部门的工资记录数#

select d.dept_no, d.dept_name, count(s.salary) sum from salaries s left join dept_emp de on s.emp_no = de.emp_no left join departments d on d.dept_...

Mysql

2021-10-27

0 291

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

select user_id,min(date) first_buy_date,count(user_id) cnt from order_info where date > '2025-10-15' and product_name in ('C++','Java','Python') an...

Mysql

2021-10-26

0 295

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

select id , job ,score from grade g where score > ( select round(avg(score),3) from grade sub where g.job = sub.job ) order by id

Mysql

2021-10-26

0 297

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

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

Mysql

2021-10-25

0 277

python3实现阿拉伯数字和中文数字转换

# transNum num= input("请输入阿拉伯数字：") han = "零一二三四五六七***" for i in range(len(num)): numsplit = int(num[i]) print(han[numsp...

2021-10-25

0 443

Python绘制金字塔

# pyramid import turtle as t t.pencolor("gold") t.pensize(2) count = 10 while count > 0: for i in range(count): t.fd(10) ...

2021-10-25

0 410

Python画熊头像

用python3画了一只丑熊 ```python3 # bear import turtle as t # 脸 t.pensize(2) t.color('yellow') t.pencolor("black") t.begin_fill() t.circle(40,36...

2021-10-25

0 518

读取文件时出现“UnicodeDecodeError: ‘gbk‘ codec can‘t decode byte 0x80 in position 42: illegal multibyte se”

原来代码如下 #coding=utf-8 testF1= open("testFi.txt","r") for line in testF1: print(line) 结果出现错误 UnicodeDecodeError: 'gb...

2021-10-25

0 607