对牛可弹琴

分类

题解(36)

/ 注册

全部文章（共34篇）

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

```SELECT answer_date, author_id, count( issue_id ) author_cnt FROM answer_tb GROUP BY answer_date, author_id HAVING count( issue_id ) >=...

Mysql

2022-02-19

0 251

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

```WITH t AS ( SELECT b.char_len, CASE WHEN a.author_level IN ( 1, 2 ) THEN "1-2级" WHEN a.author_level IN ( 3, 4 ) THEN "3-4级" EL...

Mysql

2022-02-19

0 300

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

```SELECT c.course_name, ROUND( AVG( TIMESTAMPDIFF( MINUTE, in_datetime, out_datetime ) ), 2 ) avg_len FROM attend_tb a LEFT JOIN course_tb c ON ...

Mysql

2022-02-19

1 429

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

```SELECT c.course_id, c.course_name, COUNT( a.in_datetime ) online_num FROM attend_tb a LEFT JOIN course_tb c ON a.course_id = c.course_id WHE...

Mysql

2022-02-19

0 387

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

```WITH t AS ( SELECT a.*, ( b.tag_price * sales_num ) AS ori_price FROM sales_tb a LEFT JOIN product_tb b ON a.item_id = b.item_id WHERE...

Mysql

2022-02-19

0 240

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

```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