Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of $10$ to $50$ in the Hours column?

WHERE Hours $=$MIN$(10)$ and MAx$(50)$

WHERE Hours IN $10,50$

WHERE Hours BETWEEN $10$ AND $50$

WHERE Hours $=10$ and Hours $=50$