牛客538341495号

分类

/ 注册

全部文章（共6篇）

题解 | 统计每个产品的销售情况

with t1 as ( select customer_id,o.product_id product_id,quantity,order_date,unit_price from orders o left join products p on o.product...

2025-07-09

0 9

题解 | 重塑矩阵

from typing import List, Tuple, Union import numpy as np def reshape_matrix(a: List[List[Union[int, float]]], new_shape: Tuple[int, int]) -> List[...

2025-07-01

0 15

题解 | 矩阵和向量的点积

def matrix_vector_dot_product(matrix, vector): res = [] # 补全代码 if len(matrix[0]) != len(vector): return -1 while matrix and ve...

2025-07-01

0 18

题解 | 矩阵转置

from typing import List, Union # 使用 Union 来表示类型可以是 int 或 float def transpose_matrix(a: List[List[Union[int, float]]]) -> List[List[Union[int, floa...

2025-07-01

0 15

题解 | 网易云音乐推荐(网易校招笔试真题)

WITH follow_user_1 AS ( SELECT * FROM follow WHERE user_id = 1 ), recommended_music AS ( SELECT DISTINCT music.id, mu...

2025-06-17

0 24

题解 | 每个月Top3的周杰伦歌曲

-- 定义CTE临时表t1：筛选18-25岁用户在2022年播放周杰伦歌曲的记录 WITH t1 AS ( SELECT play_log.fdate fdate, play_log.user_id user_id, song_info.so...

2025-06-17

1 23