I don't have any proper experience with MySQL but need to make a query from python to a database that would return a list of vacant apartments.
So, I know the number_of_beds, start_date and end_date and need to get a list of available apartments.
The two MySQl tables that I can query basically are:
APARTMENTS: (all available apartments)
Apartments are available up to and on start_date and from and including end_date.
Appreciate any help that would save me from dwelving into SQL queries