How can such a request be made?

Question

PostgreSQL

Brothers, how can you add a double condition? Yes, this is not correct, but how can you do it? Pm pzh..

select * from client_info 
where date_from and date_to  between  '2020-11-23'::date  and '2020-11-29'::date

Answer 1

...
where date_from between  '2020-11-23'::date  and '2020-11-29'::date 
   and date_to  between  '2020-11-23'::date  and '2020-11-29'::date