Coordinate: 31° 39' N, 81° 9' W
climate data are based on Keith-Lucas et al. (1999)
SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=1768 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1768SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1228SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1768 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='virescens' OR junior_species='virescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='virescens' OR species='virescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='virescens' OR species='virescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='virescens' OR junior_species='virescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Empidonax' AND (species='virescens' OR species='virescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Setophaga' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polioptila' AND (junior_species='caerulea' OR junior_species='caerulea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polioptila' AND (species='caerulea' OR species='caerulea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polioptila' AND (species='caerulea' OR species='caerulea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polioptila' AND (junior_species='caerulea' OR junior_species='caerulea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polioptila' AND (species='caerulea' OR species='caerulea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parus' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parus' AND (species='carolinensis' OR species='carolinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parus' AND (species='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryothorus' AND (junior_species='ludovicianus' OR junior_species='ludovicianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thryothorus' AND (species='ludovicianus' OR species='ludovicianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thryothorus' AND (species='ludovicianus' OR species='ludovicianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryothorus' AND (junior_species='ludovicianus' OR junior_species='ludovicianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thryothorus' AND (species='ludovicianus' OR species='ludovicianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiscalus' AND (junior_species='quiscula' OR junior_species='quiscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quiscalus' AND (species='quiscula' OR species='quiscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quiscalus' AND (species='quiscula' OR species='quiscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiscalus' AND (junior_species='quiscula' OR junior_species='quiscula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quiscalus' AND (species='quiscula' OR species='quiscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='trichas' OR junior_species='trichas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geothlypis' AND (species='trichas' OR species='trichas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geothlypis' AND (species='trichas' OR species='trichas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='trichas' OR junior_species='trichas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Geothlypis' AND (species='trichas' OR species='trichas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picoides' AND (species='pubescens' OR species='pubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picoides' AND (species='pubescens' OR species='pubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Picoides' AND (species='pubescens' OR species='pubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parus' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parus' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parus' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardinalis' AND (junior_species='cardinalis' OR junior_species='cardinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cardinalis' AND (species='cardinalis' OR species='cardinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardinalis' AND (species='cardinalis' OR species='cardinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardinalis' AND (junior_species='cardinalis' OR junior_species='cardinalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cardinalis' AND (species='cardinalis' OR species='cardinalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimus' AND (junior_species='polyglottos' OR junior_species='polyglottos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimus' AND (species='polyglottos' OR species='polyglottos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimus' AND (species='polyglottos' OR species='polyglottos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimus' AND (junior_species='polyglottos' OR junior_species='polyglottos')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mimus' AND (species='polyglottos' OR species='polyglottos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parula' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parula' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parula' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parula' AND (junior_species='americana' OR junior_species='americana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parula' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seiurus' AND (junior_species='aurocapilla' OR junior_species='aurocapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seiurus' AND (junior_species='aurocapilla' OR junior_species='aurocapilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='ciris' OR junior_species='ciris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passerina' AND (species='ciris' OR species='ciris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passerina' AND (species='ciris' OR species='ciris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='ciris' OR junior_species='ciris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Passerina' AND (species='ciris' OR species='ciris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='pinus' OR junior_species='pinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='pinus' OR species='pinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='pinus' OR species='pinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='pinus' OR junior_species='pinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Setophaga' AND (species='pinus' OR species='pinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protonotaria' AND (junior_species='citrea' OR junior_species='citrea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protonotaria' AND (species='citrea' OR species='citrea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protonotaria' AND (species='citrea' OR species='citrea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protonotaria' AND (junior_species='citrea' OR junior_species='citrea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protonotaria' AND (species='citrea' OR species='citrea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanerpes' AND (junior_species='carolinus' OR junior_species='carolinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanerpes' AND (species='carolinus' OR species='carolinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanerpes' AND (species='carolinus' OR species='carolinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanerpes' AND (junior_species='carolinus' OR junior_species='carolinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanerpes' AND (species='carolinus' OR species='carolinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agelaius' AND (junior_species='phoeniceus' OR junior_species='phoeniceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agelaius' AND (species='phoeniceus' OR species='phoeniceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agelaius' AND (species='phoeniceus' OR species='phoeniceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agelaius' AND (junior_species='phoeniceus' OR junior_species='phoeniceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agelaius' AND (species='phoeniceus' OR species='phoeniceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='calendula' OR junior_species='calendula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Regulus' AND (species='calendula' OR species='calendula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Regulus' AND (species='calendula' OR species='calendula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='calendula' OR junior_species='calendula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Regulus' AND (species='calendula' OR species='calendula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='rubra' OR junior_species='rubra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piranga' AND (species='rubra' OR species='rubra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piranga' AND (species='rubra' OR species='rubra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='rubra' OR junior_species='rubra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Piranga' AND (species='rubra' OR species='rubra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='ustulatus' OR junior_species='ustulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='ustulatus' OR species='ustulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='ustulatus' OR species='ustulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='ustulatus' OR junior_species='ustulatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catharus' AND (species='ustulatus' OR species='ustulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='griseus' OR junior_species='griseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='griseus' OR species='griseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='griseus' OR species='griseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='griseus' OR junior_species='griseus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vireo' AND (species='griseus' OR species='griseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonotrichia' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonotrichia' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zonotrichia' AND (species='albicollis' OR species='albicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocichla' AND (junior_species='mustelina' OR junior_species='mustelina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylocichla' AND (species='mustelina' OR species='mustelina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylocichla' AND (species='mustelina' OR species='mustelina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocichla' AND (junior_species='mustelina' OR junior_species='mustelina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylocichla' AND (species='mustelina' OR species='mustelina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helmitheros' AND (junior_species='vermivorum' OR junior_species='vermivorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helmitheros' AND (species='vermivorum' OR species='vermivorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helmitheros' AND (species='vermivorum' OR species='vermivorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helmitheros' AND (junior_species='vermivorum' OR junior_species='vermivorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helmitheros' AND (species='vermivorum' OR species='vermivorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='flavifrons' OR junior_species='flavifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='flavifrons' OR species='flavifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='flavifrons' OR species='flavifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='flavifrons' OR junior_species='flavifrons')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vireo' AND (species='flavifrons' OR species='flavifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='dominica' OR junior_species='dominica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='dominica' OR species='dominica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='dominica' OR species='dominica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='dominica' OR junior_species='dominica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Setophaga' AND (species='dominica' OR species='dominica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1768