摘要: leetcode 1393 股票的资本损益 select p1.stock_name, (p2.price - p1.price) as capital_gain_loss from ( select s1.stock_name, s1.operation, sum(s1.price) as pri 阅读全文
posted @ 2023-06-02 15:54 Carl_ZhangJH 阅读(17) 评论(0) 推荐(0)
摘要: leetcode 1341 电影评分 ( select u1.name as results from Users u1 left join( select mr1.user_id, count(mr1.rating) as c1 from MovieRating as mr1 group by m 阅读全文
posted @ 2023-06-02 12:05 Carl_ZhangJH 阅读(32) 评论(0) 推荐(0)