What is the method of utilizing the outcome of SQL aggregate within an IF statement?

edit

To utilize the outcome of SQL aggregate within an IF statement, you can use a subquery. Here is an example:

IF (SELECT AVG(salary) FROM employees) > 50000 
THEN 
    PRINT 'The average salary is greater than 50000'
ELSE 
    PRINT 'The average salary is less than or equal to 50000'
END IF;

In this example, the IF statement checks whether the average salary of all employees is greater than 50000. If it is, then it prints a message saying so. If it is not, then it prints a message saying the average salary is less than or equal to 50000.