Project

General

Profile

« Previous | Next » 

Revision 12916

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: fixed typos in column aliases

View differences:

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