排名
用户解题统计
过去一年提交了
勋章 ①金银铜:在竞赛中获得第一二三名;②好习惯:自然月10天提交;③里程碑:解决1/2/5/10/20/50/100/200题;④每周打卡挑战:完成每周5题,每年1月1日清零。
收藏
收藏日期 | 题目名称 | 解决状态 |
---|---|---|
没有收藏的题目。 |
评论笔记
评论日期 | 题目名称 | 评论内容 | 站长评论 |
---|---|---|---|
2024-12-26 | Halo出行-通勤活跃用户标签开发  |
提交记录
提交日期 | 题目名称 | 提交代码 |
---|---|---|
2024-12-27 | 赌王争霸赛-盖哥要玩87o  |
SELECT CONCAT(card1, card2) AS card12, IF( EXISTS ( SELECT 1 FROM hand_probabilities WHERE hand = CONCAT(SUBSTRING(card1, 1, 1), SUBSTRING(card2, 1, 1)) OR hand = CONCAT(SUBSTRING(card2, 1, 1), SUBSTRING(card1, 1, 1)) ), 1, 0 ) AS if_garrett FROM hand_permutations; |
2024-12-27 | 招建银行信用卡中心客户挽留-电商平台分类  |
SELECT DISTINCT mch_nm AS merchant_name, CASE WHEN mch_nm LIKE '%拼多多%' OR mch_nm LIKE '%寻梦信息科技%' THEN '拼多多' WHEN mch_nm LIKE '%京东%' THEN '京东' WHEN mch_nm LIKE '%淘宝%' THEN '淘系' WHEN mch_nm LIKE '%抖音%' THEN '抖音' WHEN mch_nm LIKE '%小红书%' THEN '小红书' ELSE '其他' END AS platform FROM ccb_trx_rcd; |
2024-12-27 | 招建银行信用卡中心客户挽留-电商平台分类  |
SELECT mch_nm AS merchant_name, CASE WHEN mch_nm LIKE '%拼多多%' OR mch_nm LIKE '%寻梦信息%' THEN '拼多多' WHEN mch_nm LIKE '%京东%' THEN '京东' WHEN mch_nm LIKE '%淘宝%' OR mch_nm LIKE '%天猫%' OR mch_nm LIKE '%淘%' THEN '淘系' WHEN mch_nm LIKE '%抖音%' THEN '抖音' WHEN mch_nm LIKE '%小红书%' THEN '小红书' ELSE '其他' END AS platform FROM ccb_trx_rcd; |
2024-12-27 | 招建银行信用卡中心客户挽留-电商平台分类  |
SELECT DISTINCT mch_nm AS merchant_name, CASE WHEN mch_nm LIKE '%拼多多%' OR mch_nm LIKE '%寻梦信息科技%' THEN '拼多多' WHEN mch_nm LIKE '%京东%' THEN '京东' WHEN mch_nm LIKE '%淘宝%' OR mch_nm LIKE '%天猫%' OR mch_nm LIKE '%淘%' THEN '淘系' WHEN mch_nm LIKE '%抖音%' THEN '抖音' WHEN mch_nm LIKE '%小红书%' THEN '小红书' ELSE '其他' END AS platform FROM ccb_trx_rcd; |