# __sm_ext_mgmt

type: QueryHistory
value:
SELECT surveys.year, surveys.month, surveys.day, species.genus, species.species
FROM surveys
JOIN species ON surveys.species = species.species_id


type: QueryHistory
value:
SELECT species.genus, species.species, surveys.wgt 
FROM surveys
JOIN species ON surveys.species = species.species_id


type: QueryHistory
value:
SELECT plots.plot_type, AVG(surveys.wgt)
FROM surveys
JOIN plots ON surveys.plot= plots.plot_id
GROUP BY plots.plot_type


