Revision 12916
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql | ||
|---|---|---|
| 110 | 110 |
|
| 111 | 111 |
CREATE OR REPLACE VIEW _specimens_12_distinct_collector_name_collect_num_date_w_count AS |
| 112 | 112 |
SELECT IFNULL("recordedBy",'') AS "collectorName", IFNULL("collectorNumber",'') AS "collectionNumber",
|
| 113 |
IFNULL("CollectedDate",'') AS "dataCollected", COUNT(*) AS "specimenRecords"
|
|
| 113 |
IFNULL("CollectedDate",'') AS "dateCollected", COUNT(*) AS "specimenRecords"
|
|
| 114 | 114 |
FROM "Ecatalog_all" |
| 115 | 115 |
GROUP BY "recordedBy", "collectorNumber", "CollectedDate" |
| 116 | 116 |
ORDER BY "recordedBy", "collectorNumber", "CollectedDate"; |
Also available in: Unified diff
validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: fixed typos in column aliases