选择姓氏为 Maroni 的最大体重和最小体重的差异

Question

rree

Answer 1

你想得太复杂了。无需任何子查询即可找到差异：

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