Like the title says, I would like to make it so all the values returned are 0-1. So my first try was like in the title, but I get an error about not being able to mix aggregate and raw field types. Is something like this possible? Thanks see below for better explanation.
Select field1 from measurement1;
But I want