datafest
                                
                                 datafest copied to clipboard
                                
                                    datafest copied to clipboard
                            
                            
                            
                        Add answers to 'merging data' exercises
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