对牛可弹琴

分类

题解(36)

/ 注册

全部文章（共50篇）

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

```import java.util.HashSet; public class Solution{ public int duplicate (int[] numbers) { // write code here int length = number...

Mysql

2022-02-20

0 214

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

```WITH t AS ( SELECT a.author_id, a.issue_id, b.issue_type FROM answer_tb a LEFT JOIN issue_tb b ON a.issue_id = b.issue_id ) SELECT ...

Mysql

2022-02-19

0 283

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

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