datafest icon indicating copy to clipboard operation
datafest copied to clipboard

Add answers to 'merging data' exercises

Open devbioinfoguy opened this issue 8 years ago • 1 comments

devbioinfoguy avatar Jan 20 '17 20:01 devbioinfoguy

select * from Survey order by quant, reading DESC

select * from Survey where quant=‘sal’ and (reading < 0 OR reading > 1.0);

select count(*) from Survey where read=‘sal’ and (quant < 0 AND quant > 1.0)

select personal, family, quant, reading from Person JOIN Survey WHERE Survey.person = Person.id

devbioinfoguy avatar Jan 20 '17 20:01 devbioinfoguy