MIN MAX - Aggregate Functions not working

SQL
1

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

MIN MAX FUNCTIONS
MIN MAX FUNCTIONS1774×906 138 KB

2

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

3

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

4

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