回答編集履歴

推敲

2021/10/01 03:47

投稿

スコア25430

answer CHANGED Viewed

@@ -3,7 +3,7 @@
 ```SQL
 select * from ZZZ
 where (ID, 計測日) in (
-        select ID, coalesce(max(case when BMI is not Nul then 計測日 end), max(計測日))
+        select ID, coalesce(max(case when BMI is not Null then 計測日 end), max(計測日))
         from  ZZZ
         where 計測日 <= 21/09/15
         group by ID