右下角图片

排名

用户解题统计

过去一年提交了

勋章 ①金银铜:在竞赛中获得第一二三名;②好习惯:自然月10天提交;③里程碑:解决1/2/5/10/20/50/100/200题;④每周打卡挑战:完成每周5题,每年1月1日清零。

收藏

收藏日期 题目名称 解决状态
2024-12-25 Halo出行-通勤活跃用户标签开发  未解决

评论笔记

评论日期 题目名称 评论内容 站长评论
没有评论过的题目。

提交记录

提交日期 题目名称 提交代码
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%'or mch_nm like '%小红书%' then '小红书' else '其他' end as platformfrom (select * from ccb_trx_rcd where left(mch_nm,1) != '财')a
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%'or mch_nm like '%小红书%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变幻%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case whenmch_nm like '%寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%' or mch_nm like '%空间变幻%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%' or mch_nm like '%拼多多%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case whenmch_nm like '%上海寻梦%'then '拼多多' whenmch_nm like '%京东%' then '京东' whenmch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' whenmch_nm like '%合众%'or mch_nm like '%抖音%'then '抖音'when mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case when substr(mch_nm,5,6)= '拼' or mch_nm like '%上海寻梦%'then '拼多多' when substr(mch_nm,1,2)= '京' or mch_nm like '%京东%' then '京东' when substr(mch_nm,5,6)= '淘' or mch_nm like '%淘宝%'or mch_nm like '%天猫%' or mch_nm like '%杭州今日卖场%' then '淘系' when substr(mch_nm,5,6)= '抖' or mch_nm like '%合众%'or mch_nm like '%抖音%'then '抖音'when substr(mch_nm,5,6)= '小'or mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
select mch_nm as merchant_name,case when substr(mch_nm,5,6)= '拼' or mch_nm like '%上海寻梦%'then '拼多多' when substr(mch_nm,1,2)= '京' or mch_nm like '%京东%' then '京东' when substr(mch_nm,5,6)= '淘' or mch_nm like '%淘宝%'or mch_nm like '%天猫%' then '淘系' when substr(mch_nm,5,6)= '抖' or mch_nm like '%合众%'or mch_nm like '%抖音%'then '抖音'when substr(mch_nm,5,6)= '小'or mch_nm like '%行吟%' then '小红书' else '其他' end as platformfrom ccb_trx_rcd
2024-10-24 分组与聚合函数(6)想知道渣男有多坏,疯狂使用GroupBy 
select * from cmb_usr_trx_rcd limit 5