Could you share what you wrote for step 1? I thought I had a fix in place for anything ending in ; but there could be other things that are causing errors when put into with
select staff_name, pod_group, weight_kg
from crew
where status != "deceased";
Error: Query failed: SelectSQL: queryAll: near ";": syntax error
select
staff_name,
pod_group,
case
when weight_kg > 10 then weight_kg
else weight_kg * 10
end as fixed_weight
from filtered_crewJust tested it, even added a bunch of spaces and line breaks at the end to see if that was confusing things but I still seemed to get through ok.
I want to fix this but for now could you try the steps without putting a semicolon at the end? Hopefully your patience/enthusiasm hasn't totally worn out at this point but even if you don't feel like reporting back I'm keen for you to be able to get past the frustration if you're still interested! :-)
Yeah, it works if I omit the semicolon.
Hmmm, now that I think about it, I don't think I deleted the pre-filled comment when writing my original query, could it be that I thus fooled your semicolon eraser? Something like
select * from crew;
/* blablabla */