Comment

Comment by kroltan

I lost the contents because I closed the window since then, but it was something like

    select staff_name, pod_group, weight_kg
    from crew
    where status != "deceased";
Interestingly, running this now gives me a different error on step 2, which definitely did not happen before:

    Error: Query failed: SelectSQL: queryAll: near ";": syntax error
My step 2 is:

    select
      staff_name,
      pod_group,
      case
        when weight_kg > 10 then weight_kg
        else weight_kg * 10
      end as fixed_weight
    from filtered_crew
parent kroltan 3 years ago

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton