>I cannot imagine SQL query with 5-6 between for the case of right database design.

Maybe this will stretch your imagination:
Millions of records in the table. Each record has at least 3 fields that can hold over 20,000 possible values. The records tie back to a parent table in a many-to-one relationship. We need to retrieve records based on the presence or absence of myriad combinations of those 20,000 different values (which are an indication of health status and treatments). Welcome to the world of clinical software, which is substantially different from the analytical needs of the retail sector.