右下角图片

排名

用户解题统计

过去一年提交了

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

收藏

收藏日期 题目名称 解决状态
没有收藏的题目。

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
WITH cte AS (
SELECT 
mch_nm AS merchant_name,
'拼多多' AS platform
FROM 
ccb_trx_rcd
WHERE 
mch_nm LIKE '%拼多多%'
UNION ALL
SELECT 
mch_nm AS merchant_name,
'京东' AS platform
FROM 
ccb_trx_rcd
WHERE 
mch_nm LIKE '%京东%'
UNION ALL
SELECT 
mch_nm AS merchant_name,
'淘系' AS platform
FROM 
ccb_trx_rcd
WHERE 
mch_nm LIKE '%淘宝%' 
OR mch_nm LIKE '%天猫%' 
OR mch_nm LIKE '%支付宝%'
UNION ALL
SELECT 
mch_nm AS merchant_name,
'抖音' AS platform
FROM 
ccb_trx_rcd
WHERE 
mch_nm LIKE '%抖音%'
UNION ALL
SELECT 
mch_nm AS merchant_name,
'小红书' AS platform
FROM 
ccb_trx_rcd
WHERE 
mch_nm LIKE '%小红书%'
)
SELECT 
merchant_name,
platform
FROM 
cte
UNION ALL
SELECT 
mch_nm AS merchant_name,
'其他' AS platform
FROM 
ccb_trx_rcd
WHERE 
mch_nm NOT IN (
SELECT merchant_name FROM cte
);
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
SELECT 
mch_nm AS merchant_name,
(
CASE 
WHEN mch_nm REGEXP '拼多多' THEN '拼多多'
WHEN mch_nm REGEXP '京东' THEN '京东'
WHEN mch_nm REGEXP '(淘宝|天猫|支付宝)' THEN '淘系'
WHEN mch_nm REGEXP '抖音' THEN '抖音'
WHEN mch_nm REGEXP '小红书' THEN '小红书'
ELSE '其他'
END
) AS platform
FROM 
ccb_trx_rcd;
2024-10-24 招建银行信用卡中心客户挽留-电商平台分类 
SELECT 
merchant_name,
CASE 
WHEN merchant_name LIKE '%拼多多%' THEN '拼多多'
WHEN merchant_name LIKE '%京东%' THEN '京东'
WHEN merchant_name LIKE '%淘宝%' OR merchant_name LIKE '%天猫%' OR merchant_name LIKE '%支付宝%' THEN '淘系'
WHEN merchant_name LIKE '%抖音%' THEN '抖音'
WHEN merchant_name LIKE '%小红书%' THEN '小红书'
ELSE '其他'
END AS platform
FROM (
SELECT 
mch_nm AS merchant_name
FROM 
ccb_trx_rcd
) AS merchant_platform;