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