In QGIS I have two datasets: (1) one with points that have two fields, the unique identifier
"species" - either H, L or G (2) second with polygons of areas, again with unique
"PK" and each polygon has
"species" either H, L or G.
I'm not very experienced with SQLite and struggling to find the query that would return the total number of points which lie within a polygon with a matching species.