题目:原题链接(中等)
标签:SQL
解法 | 时间复杂度 | 空间复杂度 | 执行用时 |
---|---|---|---|
Ans 1 (SQL) | – | – | 661ms (27.58%) |
Ans 2 (SQL) | |||
Ans 3 (SQL) |
解法一:
SELECT SUM(B.apple_count + IFNULL(C.apple_count, 0)) AS apple_count,
SUM(B.orange_count + IFNULL(C.orange_count, 0)) AS orange_count
FROM Boxes B
LEFT JOIN
Chests C
ON B.chest_id = C.chest_id;