I have a database with information about tropical fish. I would like to make a filter using a minimum and maximum temperature. Is it possible to create a filter like that?
For example:
Fish A
Minimum temperature: 18
Maximum temperature: 24
Fish B
Minimum temperature: 22
Maximum tempterature: 27
I would like to make a search for fish that can be kept at temperatures between 23 and 28. The result should show both fish as they can be kept at 23 or 24 degrees and not showing fish that can only be kept at 29-30.