Jayneee

分类

题解(5)

/ 注册

全部文章（共3篇）

题解 | #实习广场投递简历分析(三)#

SELECT t1.job, first_year_mon, first_year_cnt, second_year_mon, second_year_cnt FROM (SELECT job, SUBSTR(date,1,7) AS first_year_mon, SUM(num) AS firs...

SQL

2021-06-22

0 415

题解 | #实习广场投递简历分析(二)#

SELECT job, SUBSTR(date,1,7) AS mon, SUM(num) AS cnt FROM resume_info WHERE date LIKE '2025-%' GROUP BY job, mon ORDER BY mon DESC, cnt DESC

SQL

2021-06-22

0 420

题解 | #牛客每个人最近的登录日期(二)#

SELECT u.name AS u_n, c.name AS c_n, MAX(date) AS date FROM login AS l, user AS u, client AS c WHERE l.user_id = u.id AND l.client_id = c.id GROUP BY...

SQL

2021-06-22

2 767