Need help from some MySQL experts...

https://xlinesoft.com/phprunner/docs/query_designer.htm
WHERE clause (using ">" DATE rather than "=" 2004)
You can add where clause in the Filter column. If you need to add two or more conditions use Or columns.

GROUP BY clause (using COUNT in your case rather than seen AVG)
To add GROUP BY clause click the Group By button and select one of grouping function in Group By column.

Once done, you can proceed to SQL tab to see on how yours differs from the code generated as above.
Else you need to make good use of DEBUG function as per step-by-step tutorial as seen under:
https://xlinesoft.com/blog/2016/05/02/troubleshooting-sql-queries/

Will give it a try.

Thanks walk2fly

Something like this (assumes datetime field, else use CurDate() instead of NOW()) :-
SELECT

ID,

Item,

Received,

DateDiff(NOW(),Received) AS Elapsed,

IF(DateDiff(NOW(),Received)>365,1,0) AS Longer

FROM Inventory

Thanks Kevin, worked perfectly for what I was trying to achieve.

Paul