i know the sql language,but i am unfamiliar with arcgis sql expression/syntax
In ArcGIS you only have access to the WHERE clause of a SQL statement. Most SQL is supported as long as it is only the WHERE clause.
http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm
https://enterprise.arcgis.com/en/server/latest/administer/linux/about-standardized-queries.htm
in the above code why "when" used also what is onStatisticField, outStatisticFieldName,statisticType it will be very much helpful if you explain.Thank you
Anupan,
In that code snippit the when is part of an Arcade expression.
"CASE WHEN (yearCompleted >= '1975' AND yearCompleted <= '1999') THEN 1 ELSE 0 END",
https://developers.arcgis.com/javascript/3/jshelp/arcade.html