3.字符串处理函数/正则

1.1667.修复表中的名字

【JMao】简单函数解法+分享刷题经验 - 修复表中的名字 - 力扣（LeetCode）

 

 

 

# Write your MySQL query statement below
SELECT user_id,CONCAT(UPPER(LEFT(name,1)),LOWER(SUBSTRING(name,2))) name
FROM Users
ORDER BY user_id;

 

2.1484.按日期分组销售产品

# Write your MySQL query statement below
SELECT 
   sell_date,COUNT(distinct product) num_sold,GROUP_CONCAT(distinct product) products
FROM
   Activities
GROUP BY sell_date
ORDER BY sell_date;

 

3.1527.患某种疾病的患者

# Write your MySQL query statement below
SELECT *
FROM Patients 
WHERE conditions Like '% DIAB1%' OR conditions Like 'DIAB1%';