对牛可弹琴

题解

/ 注册

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

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

```WITH t AS ( SELECT b.*, a.result, a.date, CASE WHEN result = "right" THEN 1 ELSE 0 END flag FROM user_profile b LEFT JOI...

Mysql

2022-02-22

0 231

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

```import java.util.Arrays; public class Solution { public int MoreThanHalfNum_Solution(int [] array) { if (array.length==1){ ...

Mysql Java

2022-02-21

0 278

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

```public class Solution { public boolean Find(int target, int [][] array) { int rows = array.length; int columns = array[0].lengt...

Mysql

2022-02-21

0 210

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

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