MIN MAX - Aggregate Functions not working

Hi Folks, When writing this query I’m getting an error message when i use MAX and MIN, but the AVG works fine. If you look at the picture the ‘MIN’ and ‘MAX’ statements are not in bold in the query, but the AVG is. Any thoughts on why this is? I assume it’s something simple I’m overlooking.
Using MySQL workbench

There mustn’t be a space between the function name and the (.

Thanks Sam. I figured it was something simple. :+1:

please how did you resolve the issue, i am having the same problem with the min and max.
thanks