select count(pof.path) as db_files_open, oi.version
 from osquery_info as oi 
 join process_open_files as pof on pof.pid = oi.pid 
 where pof.path like '/private/var/osquery/osquery.db/00%' ;