麦田里的大白免

分类

题解(1)

/ 注册

全部文章（共4篇）

题解 | #查询连续登陆的用户#

SELECT DISTINCT user_id FROM ( SELECT user_id, DATE_SUB(t2.log_day, INTERVAL t2.ranking DAY) date2 FRO...

2024-11-15

0 34

题解 | #每个商品的销售总额#

SELECT product_name, total_sales, ROW_NUMBER() OVER(PARTITION BY t2.category ORDER BY t1.total_sales DESC) category_rank FROM ( ...

2024-11-15

0 43

题解 | #推荐内容准确的用户平均评分#

SELECT AVG(score) FROM ( SELECT DISTINCT rec_info_l, rec_user, score FROM reco...

2024-11-15

6 39

题解 | #正则表达式匹配#

import java.util.*; public class Solution { public boolean match (String str, String pattern) { // write code here ArrayList<String> pat...

Java

2022-05-08

0 211