Please go to: https://www.w3schools.com/sql/ to solve ALL following questions:

1. Convert the value of CURRENT_TIMESTAMP function to DATE data type using the CAST Function.

2. Write a query to display the CustomerID and the OrderDate from Orders table where the orderdate is less or equal to August, 23 1996.

3. Change the previous query to return the CustomerID and the OrderDate from Orders table where OrderDate is between August, 23 1996 and November 28 1996.