- IS NULL Condition
- IS NOT NULL Condition
- And Operator
- OR Operator
- AND OR Operator
- BETWEEN Operator
- JOINS
- VIEW
- SUM function
- COUNT function
- AVG function
- MIN function
- MAX function
- FIRST function
- LAST function
- ADDDATE() FUNCTION
- DATE() FUNCTION
- ADDTIME() FUNCTION
- CURDATE() FUNCTION
- DATE_ADD() FUNCTION
- DATE_FORMAT() FUNCTION
- DATEDIFF() FUNCTION
- DAYNAME() FUNCTION
- DAYOFMONTH() FUNCTION
- DAYOFWEEK() function
- DAYOFYEAR() function
- FROM_DAYS() FUNCTION
- DAY() FUNCTION