牛客264897283号

分类

/ 注册

全部文章（共51篇）

题解 | 牛客网用户数据集的大小

import pandas as pd dd=pd.read_csv('Nowcoder.csv',sep=',',dtype=object) print(dd.shape)

2025-03-12

0 63

题解 | 用pandas查看牛客网用户数据

import pandas as pd dd=pd.read_csv('Nowcoder.csv',sep=',',dtype=object) print(dd.head(6))

2025-03-12

0 81

题解 | 批量插入数据

insert into actor (actor_id, first_name, last_name, last_update) values (1 ,'PENELOPE' ,'GUINESS', '2006-02-15 12:34:33'), (2 ,'NICK', 'WA...

2025-03-12

0 67

题解 | 创建一个actor表，包含如下列信息

CREATE TABLE actor ( actor_id smallint (5) not null comment '主键id', first_name varchar(45) not null comment '名字', last_name varchar(45) no...

2025-03-12

0 80

题解 | 使用子查询的方式找出属于Action分类的所有电影对应的title,description

select a.title, a.description from film a join film_category c using (film_id) join category b using (category_id) where b.nam...

2025-03-12

0 77

题解 | 使用join查询方式找出没有分类的电影id以及名称

select film_id, title from film where film_id not in ( select f.film_id from film f ...

2025-03-12

0 62

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

SELECT e.emp_no AS emp_no, dm.emp_no AS manager_no, e.salary AS emp_salary, mg.salary AS manager_salary FROM salaries e INNER ...

2025-03-12

0 57

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

SELECT e.emp_no AS emp_no, dm.emp_no AS manager_no, e.salary AS emp_salary, mg.salary AS manager_salary FROM salaries e INNER JO...

2025-03-12

0 63

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

select b.dept_no, d.emp_no, d.salary from salaries d left join dept_emp b using (emp_no) where d.emp_no not in( select...

2025-03-12

2 67

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

select b.dept_no, d.emp_no, d.salary from salaries d left join dept_emp b using (emp_no) where d.emp_no not in ( sele...

2025-03-12

0 57