Revision 12935
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql | ||
|---|---|---|
| 20 | 20 |
; |
| 21 | 21 |
|
| 22 | 22 |
CREATE VIEW _specimens_02_count_of_unique_verbatim_families AS |
| 23 |
SELECT count(DISTINCT family) AS families |
|
| 24 |
FROM taxonverbatim |
|
| 25 |
WHERE taxonverbatim.source_id = (SELECT source_by_shortname('NY'))
|
|
| 26 |
AND family IS NOT NULL |
|
| 23 | 27 |
; |
| 24 | 28 |
|
| 25 | 29 |
CREATE VIEW _specimens_03_list_of_verbatim_families AS |
Also available in: Unified diff
validation/aggregating/specimens/qualitative_validations_specimens.sql: implemented _specimens_02_count_of_unique_verbatim_families