Answer to Question #250391 in Databases | SQL | Oracle | MS Access for rosebud21

Question

PRACTICAL: Question 5 (Marks: 10)

Create a view called vwPetSalesDetails that will display the customer id, pet id, pet price and sales date. In your solution only display the sales that occurred between 15 March 2020 and 18 March 2020.

how to code for the sales between that date only. please provide sample code. thank you

Answer 1

CREATE VIEW vwPetSalesDetails AS
  SELECT customer id, pet id, pet price and sales date
  FROM tables
  WHERE sales date between '5 March 2020' and '18 March 2020'