Dynamic hotel rates

Question

I have table of rates with columns [check-in, check-out, price]

2021-05-12 2021-05-18 30$
2021-05-19 2021-05-23 35$

now if clients search for date range
2021-05-15 to 2021-05-22
rate must be calculated from two rows
3 days from first row and 4 from second
need the query for dynamic rates changes

Answer 1

SELECT TOP number|percent column_name(s)
FROM table_name
WHERE condition;

Answer 2

S-Adil 👑 show me the table

Answer 3

JOY it's not about that you think
clients search in date range where it exists between two rows

Answer 4

if I search for date range 2021-05-12 to 2021-05-22 this row rate isn't exists it must calculated from both rows
30$
35$

Answer 5

rates table

check-in check-out price
2021-05-12 2021-05-18 30$
2021-05-19 2021-05-23 35$

Answer 6

JOY check-in and check-out is date range from - to