[database-leetcode]1777 Product's Price for Each Store
2021-03-13 08:18 作者:您是打尖兒還是住店呢 | 我要投稿
Write an SQL query to find the price of each product in each store.
Return the result table in?any order.
The query result format is in the following example:


sql:
題目屬于簡單型:
使用case when做條件判斷,然后進行分析,最后sum進行匯總,這種一般要小心是否需要distinct,其他沒有問題,
標(biāo)簽: