Project

General

Profile

« Previous | Next » 

Revision 1254

Added by Aaron Marcuse-Kubitza almost 13 years ago

specimens verification: Added # binomials test

View differences:

specimens.ref.sql
10 10 
SELECT '# species' AS ___;
11 11 
SELECT count(DISTINCT Genus, Species) AS count FROM nybg_raw;
12 12 

  		




  
  13
  
    
SELECT '# binomials' AS ___;


  		




  
  14
  
    
SELECT count(DISTINCT ScientificName) AS count FROM nybg_raw;


  		




  
  15
  
    

  		




  13
  16
  
    
/*


  		




  14
  
  
    
SELECT 


  		




  15
  
  
    
(


  		




  16
  
  
    
SELECT COUNT(DISTINCT Family) FROM nybg_raw WHERE Family IS NOT NULL


  		




  17
  
  
    
) AS families, 


  		




  18
  
  
    
(


  		




  19
  
  
    
SELECT COUNT(DISTINCT Genus) FROM nybg_raw WHERE Genus IS NOT NULL


  		




  20
  
  
    
) AS genera,


  		




  21
  
  
    
(


  		




  22
  
  
    
SELECT COUNT(DISTINCT Genus, Species) FROM nybg_raw 


  		




  23
  
  
    
WHERE Genus IS NOT NULL AND Species IS NOT NULL


  		




  24
  
  
    
) AS species;


  		




  25
  
  
    

  		




  26
  17
  
    
SELECT DISTINCT CONCAT_WS(' ', Genus, Species) AS Species


  		




  27
  18
  
    
FROM nybg_raw 


  		




  28
  19
  
    
WHERE Genus IS NOT NULL AND Species IS NOT NULL;


  		












Also available in:  Unified diff