Neon neon database (solution)

Exercise
Output solution

Attaching package: 'dplyr'
The following objects are masked from 'package:stats':

    filter, lag
The following objects are masked from 'package:base':

    intersect, setdiff, setequal, union
[1] "capture"      "plots"        "sqlite_stat1" "sqlite_stat4" "traps"       
 [1] "uid"                         "domainID"                   
 [3] "siteID"                      "plotID"                     
 [5] "trapCoordinate"              "nlcdClass"                  
 [7] "decimalLatitude"             "decimalLongitude"           
 [9] "geodeticDatum"               "coordinateUncertainty"      
[11] "elevation"                   "elevationUncertainty"       
[13] "date"                        "eventID"                    
[15] "tagID"                       "individualNid"              
[17] "taxonID"                     "scientificName"             
[19] "taxonRank"                   "identificationQualifier"    
[21] "sex"                         "reproductiveCondition"      
[23] "recapture"                   "fate"                       
[25] "replacedTag"                 "lifeStage"                  
[27] "testes"                      "nipples"                    
[29] "pregnancyStatus"             "vagina"                     
[31] "hindfootLength"              "earLength"                  
[33] "tailLength"                  "totalLength"                
[35] "weight"                      "larvalTicksAttached"        
[37] "nymphalTicksAttached"        "adultTicksAttached"         
[39] "bloodSampleID"               "bloodSampleMethod"          
[41] "fecalSampleID"               "fecalSampleCondition"       
[43] "earSampleID"                 "hairSampleID"               
[45] "whiskerSampleID"             "voucherSampleID"            
[47] "measuredBy"                  "recordedBy"                 
[49] "remarks"                     "consistencyTagIDSexQF"      
[51] "consistencyTagIDTaxonIDQF"   "consistencyTagIDLifeStageQF"
[53] "orderTagIDRecaptureQF"       "orderTagIDLifeStageQF"      
[55] "duplicateTrapCoordinateQF"   "idqQF"                      
 [1] "uid"                      "domainID"                
 [3] "siteID"                   "plotID"                  
 [5] "date"                     "night"                   
 [7] "eventID"                  "setTraps"                
 [9] "disturbedTraps"           "samplingEffort"          
[11] "samplingProtocolVersion"  "identificationReferences"
[13] "remarks"                  "duplicateNightQF"        
 [1] "uid"                       "domainID"                 
 [3] "siteID"                    "plotID"                   
 [5] "trapCoordinate"            "date"                     
 [7] "eventID"                   "trapStatus"               
 [9] "trapType"                  "duplicateTrapCoordinateQF"