#Get all orgs who have had an upgrade during the specific fiscal year (school_year)

SELECT * FROM `organizations` orgs
INNER JOIN fyer_groups fg ON fg.organizations_id = orgs.org_id

WHERE orgs.new_upgrade_date BETWEEN '2022-07-01 00:00:00' AND '2023-06-30 23:59:59'
AND fg.fyer_final = 'Y';




#See if a specific org had an upgrade during the specific fiscal year.
SELECT * FROM `organizations` orgs
INNER JOIN fyer_groups fg ON fg.organizations_id = orgs.org_id

WHERE orgs.new_upgrade_date BETWEEN '2022-07-01 00:00:00' AND '2023-06-30 23:59:59'
AND fg.fyer_final = 'Y'
AND orgs.org_id = 62;