選擇姓氏為 Maroni 的最大體重和最小體重的差異

Question

rree

Answer 1

你想得太複雜了。無需任何子查詢即可找到差異：

SELECT MAX(weight) - MIN(weight) AS weight_delta 
FROM patients WHERE last_name = 'Maroni';