SELECT '# projects' AS ___;
SELECT count(*) AS count FROM project;

SELECT 'projects' AS ___;
SELECT projectname AS project FROM project ORDER BY project;

SELECT E'each project\'s # plots' AS ___;
SELECT projectname AS project, count(*) AS plots_count
FROM project
JOIN plotevent USING (project_id)
GROUP BY project
ORDER BY project
;

SELECT '# plots' AS ___;
SELECT count(*) AS count FROM plot;

SELECT '# plot observations' AS ___;
SELECT count(*) AS count FROM plotevent;

SELECT '1st methods' AS ___;
SELECT DISTINCT
    projectname AS project
    , stemSampleMethod AS method -- placeholder until we have a method field
FROM project
JOIN plotevent USING (project_id)
ORDER BY project, method
LIMIT 10;

SELECT '1st method narratives' AS ___;
SELECT DISTINCT
    projectname AS project
    , methodNarrative AS method_narrative
FROM project
JOIN plotevent USING (project_id)
ORDER BY project, method_narrative
LIMIT 10;
