Its a query to join two tables and get the details in between given date format ,according to month (month wise) and of specific city . sample work Simple SQL…