09 2020 档案

LC 1517. Find Users With Valid E-Mails (正则)
摘要：link select * from users where mail regexp '^[a-zA-Z][a-zA-Z0-9_/\\.\\-]*(@leetcode.com)' 阅读全文
posted @ 2020-09-23 10:16 feibilun 阅读(186) 评论(0) 推荐(0)
LCP 21. 追逐游戏
摘要：https://leetcode-cn.com/problems/Za25hA/ 阅读全文
posted @ 2020-09-20 15:13 feibilun 阅读(105) 评论(0) 推荐(0)
LC 1501. 可以放心投资的国家 (left的运用)
摘要：link select name as country from ( select name,sum(duration)/count(duration) as avg from ( select t.name,t.id, c1.caller_id, c1.callee_id, c1.duration 阅读全文
posted @ 2020-09-18 09:39 feibilun 阅读(126) 评论(0) 推荐(0)
LC 1485. 按日期分组销售产品 (group_concat 用法)
摘要：link select sell_date, count(distinct product) as num_sold, group_concat(distinct product order by product asc separator ',') as products from activit 阅读全文
posted @ 2020-09-17 11:04 feibilun 阅读(147) 评论(0) 推荐(0)
LC 1479. 周内每天的销售情况
摘要：link select i.item_category as category, sum(if(date_format(order_date,'%W')='Monday',quantity,0)) as 'Monday', sum(if(date_format(order_date,'%W')='T 阅读全文
posted @ 2020-09-16 09:21 feibilun 阅读(125) 评论(0) 推荐(0)
LC LCP 20. 快速公交
摘要：link class Solution { public: #define LL long long unordered_map<int,LL> memo; int busRapidTransit(int target, int inc, int dec, vector<int>& jump, ve 阅读全文
posted @ 2020-09-15 21:07 feibilun 阅读(117) 评论(0) 推荐(0)
LC 1585. Check If String Is Transformable With Substring Sort Operations
摘要：link class Solution { public: bool isTransformable(string s, string t) { vector<deque<int>> pos(10); for(int i=0;i<s.size();i++){ pos[s[i]-'0'].push_b 阅读全文
posted @ 2020-09-15 08:23 feibilun 阅读(87) 评论(0) 推荐(0)