对牛可弹琴

题解

/ 注册

全部文章 / 题解（共29篇）

题解 | #商品交易(网易校招笔试真题)#

```SELECT b.course_id, c.course_name, ROUND( SUM( if_sign ) * 100 / COUNT( if_vw ), 2 ) AS 'sign_rate(%)' FROM behavior_tb b LEFT JOIN course_tb...

Mysql

2022-02-19

0 299

题解 | #商品交易(网易校招笔试真题)#

```SELECT LEFT ( answer_date, 10 ) answer_date, ROUND( COUNT( issue_id ) / COUNT( DISTINCT author_id ), 2 ) per_num FROM answer_tb GROUP BY LEFT...

Mysql

2022-02-19

0 280

题解 | #商品交易(网易校招笔试真题)#

```SELECT SUM(sales_price) as sales_total, ROUND(SUM(sales_price)/COUNT(DISTINCT user_id),2) as per_trans FROM sales_tb WHERE DATE_FORMAT(sales_dat...

Mysql

2022-02-19

3 945

题解 | #商品交易(网易校招笔试真题)#

```SELECT style_id, COUNT( style_id ) AS SPU_num FROM product_tb GROUP BY style_id ORDER BY SPU_num DESC;

Mysql

2022-02-19

0 296

题解 | #商品交易(网易校招笔试真题)#

```WITH t AS ( SELECT *, DATE_FORMAT( event_time, "%Y-%m" ) AS year_mont FROM tb_order_overall ) SELECT t.year_mont AS MONTH, ROUND( sum( t.total_amou...

Mysql

2022-02-19

0 286

题解 | #商品交易(网易校招笔试真题)#

```WITH t AS ( SELECT *, TIMESTAMPDIFF( SECOND, in_time, out_time ) AS subtime, date( in_time ) days FROM tb_user_log WHERE YEAR ( in_t...

Mysql

2022-02-18

0 357

题解 | #商品交易(网易校招笔试真题)#

WITH t AS ( SELECT CASE WHEN TIMESTAMPDIFF( SECOND, t1.start_time, t1.end_time ) >= t2.duration THEN 100 ELSE TIMESTAMPDIFF( SECOND, t1.start...

Mysql

2022-02-18

0 264

题解 | #商品交易(网易校招笔试真题)#

SELECT g.*, t1.total total FROM goods g INNER JOIN ( SELECT t.goods_id, SUM( t.count ) total FROM goods g LEFT JOIN trans t ON g.id = t.goods_id GROUP...

Mysql

2022-02-14

0 249

题解 | #查找薪水记录超过15次的员工号emp_no以及其对应的记录次数t#

```SELECT o.id id, o.is_group_buy is_group_buy, IFNULL(NULL,c.`name`) NAME FROM order_info o LEFT JOIN client c ON o.client_id = c.id WHERE use...

Mysql

2022-02-14

0 281