SELECT YEAR("date_time") AS "year", COUNT(DISTINCT unnamed_0) AS "sightings", COUNT(DISTINCT case_no) AS "grants"
FROM @kaggle.willianoliveiragibin_ufo_sightings.ufo_sightings_transformed
JOIN @kaggle.dushyantrathore_patent_data.patent_data
  ON YEAR("date_time") = "filing_year"
WHERE "country_code" = 'USA'
  AND "region" = 'New Mexico'
  AND YEAR("date_time") >= 1975
GROUP BY YEAR("date_time")
ORDER BY 1 ASC