How to work with databases? Several criteria, and criteria with a year?

Question

excel

Good afternoon! For example, there is a table
Commodity Delivery Price Color Weight (kg)
*************************************** **************************
1 2018-11-19 500 Krasny 5
1 2018-11-25 550 Krasny 7
1 2018-09 -19 650 Red 15
1 2018-10-19 50 Blue 11
1 2018-11-23 700 Red 7
And I have 3 tasks (questions) The
first question. I need to use database functions to determine what deliveries were from 2018-11-19 to 2018-11-23 inclusive
Question number two.I need to select all products with price above 500 but below 650 using database functions!
Question number three. how do i make it to select all red color items which weigh
7kg thanks in advance to all

Answer 1

All this in excel will successfully perform the usual filters.