Filter where clause

Integer to narrow down

score=100 or score>=200

Date to narrow down

t_date between start_date and end_date

String to narrow down

custname like 'Mike%'