小宇啊

分类

/ 注册

全部文章（共111篇）

题解 | #统计自然周平均登录次数情况#

select date_sub(login_date,interval(weekday(login_date)) day) as week_begin, round(count(*)/count(distinct uid),2) as avg_times from user_...

2024-08-27

0 99

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

select tt.user_id from (select t.user_id, t.start_date, max(date_rank) - min(date_rank) + 1 as days from (...

2024-08-27

0 117

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

select t.product_name, t.total_sales, dense_rank() over(partition by t.category order by t.total_sales desc) as category_rank from (se...

2024-08-26

0 123

题解 | #分析客户逾期情况#

select t.pay_ability, concat(round(sum(t.customer_type)*100.0/count(t.customer_id),1),"%") as overdue_ratio from (select ...

2024-08-26

0 97

题解 | #最长连续登录天数#

select user_id, max(days) as max_consec_days from (select user_id, start_date, max(date_rank) - min(date_rank) + 1...

2024-08-26

0 113

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

select tt.month, tt.ranking, tt.song_name, tt.play_pv from (select t.month, t.song_name, t.song_id, t.play_pv, ran...

2024-08-13

0 114

题解 | #重载运算#

class Coordinate: def __init__(self,x,y) -> None: self.x = x self.y = y def __str__(self) -> str: return f&quo...

2024-08-06

0 94

题解 | #修改属性2#

class Employee: def __init__(self, name, salary): self.name = name self.salary = salary def printclass(self): print(f...

2024-08-06

0 111

题解 | #修改属性1#

class Employee: def __init__(self,name,salary,age=None): self.name = name self.salary = salary self.age = age def pri...

2024-08-06

0 111

题解 | #球的表面积#

import math def surface_area(r): return round(math.pi * 4 * r**2,2) for r in [1,2,4,9,10,13]: print(surface_area(r))

2024-08-06

0 141