SOQL Statement with Filter Conditions

SELECT Name
FROM Account
WHERE AnnualRevenue > 100000000
AND Type = 'Customer - Direct'
AND LastModifiedDate = THIS_YEAR



Notice the way literal values are specified.Apostrophes must be used around String literals
but never with other data types. THIS_YEAR is a built-in relative time function.The
values of relative time functions vary based on when the query is executed. Other relative
time functions are YESTERDAY, TODAY, TOMORROW, LAST_WEEK, THIS_WEEK, NEXT_WEEK, and so forth.