Data Filter Using Date and Character.

good night. long time no writing.
tonight I wrote a little about how to use dates and characters
When building a database application, surely we will meet with a large case of data processing or enormous data retrieval.
To facilitate the process of retrieving data, and processing it, we must know how to retrieve data with certain criteria from the database. The process of filtering data is important because actually the user does not need all the data in the database,
but only a small portion.
Suppose that stored financial transaction data can contain millions of rows of data in the last few years, usually users only need transaction data in a particular month.
This article will try to explain how to filter data from databases based on several criteria at once, namely based on strings, numbers, and dates.

Suppose we have 2 (two tables), namely Orders and OrderTypes. Table Orders store transaction data along with the date and type of transaction. Table OrderTypes stores the definition of the types of transactions that exist, for example, Purchase Order transactions, Deliver Orders and so on. The appearance of the table Orders content is like in the picture below,
)

And