Backyard Brains Logo

Pro Users

SQL commands using SELECT only, others will be rejected! Columns within table sampleInfo:

▸ sampleid INTEGER ▸ deviceid INTEGER ▸ added TIMESTAMP
▸ type1 VARCHAR (First Match Species) ▸ type2 VARCHAR (Second Match Species) ▸ type3 VARCHAR (Third Match Species)
▸ per1 FLOAT (First Match Percentage) ▸ per2 FLOAT (Second Match Percentage) ▸ per3 FLOAT (Third Match Percentage)
▸ humidity INTEGER ▸ temp FLOAT ▸ light FLOAT
▸ latitude FLOAT ▸ longitude FLOAT ▸ user VARCHAR

SQL command: