力扣sql简单篇练习(三十)

力扣sql简单篇练习(三十)

1 产品销售分析V

1.1 题目内容

1.1.1 基本题目信息

1.1.2 示例输入输出

1.2 示例sql语句

# Write your MySQL query statement below
SELECT s.user_id,sum(s.quantity*p.price) spending
FROM Sales s
INNER JOIN Product p
ON s.product_id=p.product_id
GROUP BY s.user_id
ORDER BY spending desc,s.user_id asc

1.3 运行截图

2 联赛的所有比赛

2.1 基本题目内容

2.1.1 基本题目信息

2.1.2 示例输入输出

2.2 示例sql语句

# Write your MySQL query statement below
SELECT t1.team_name home_team,t2.team_name away_team
FROM Teams t1
CROSS JOIN Teams t2
ON t1.team_name <> t2.team_name

2.3 运行截图

3 每位教师所教授的科目种类的数量

3.1 题目内容

3.1.1 基本题目信息

3.1.2 示例输入输出

3.2 示例sql语句

# Write your MySQL query statement below
SELECT teacher_id,count(distinct subject_id) cnt
FROM Teacher
GROUP BY teacher_id

3.3 运行截图