[LeetCode] 1179重新格式化部门表

最新推荐文章于 2021-08-04 09:12:37 发布

你看这人，真菜

最新推荐文章于 2021-08-04 09:12:37 发布

阅读量488

点赞数

分类专栏：力扣LeetCode

本文链接：https://blog.csdn.net/qq_43584847/article/details/102831441

版权

力扣LeetCode 专栏收录该内容

225 篇文章 3 订阅

订阅专栏

1 题目描述

在这里插入图片描述

2 问题思路

3 解决代码

# Write your MySQL query statement below
select id,
       sum(case when month='Jan' then revenue end) Jan_Revenue,
       sum(case when month='Feb' then revenue end) Feb_Revenue,
       sum(case when month='Mar' then revenue end) Mar_Revenue,
       sum(case when month='Apr' then revenue end) Apr_Revenue,
       sum(case when month='May' then revenue end) May_Revenue,
       sum(case when month='Jun' then revenue end) Jun_Revenue,
       sum(case when month='Jul' then revenue end) Jul_Revenue,
       sum(case when month='Aug' then revenue end) Aug_Revenue,
       sum(case when month='Sep' then revenue end) Sep_Revenue,
       sum(case when month='Oct' then revenue end) Oct_Revenue,
       sum(case when month='Nov' then revenue end) Nov_Revenue,
       sum(case when month='Dec' then revenue end) Dec_Revenue
from Department t1
group by id
order by id