One of restrictions for SQL is that we can not apply a column function to another one. For example, you will get an error message when you execute the following statement.

select manager$\_$id$,$ max$($sum$($credit$\_$limit$))$

from employees

group by manager$\_$id

order by manager$\_$id ;

Please select a working SQL:

Question $15$ options:

select manager$\_$id$,$ max$($credit$\_$limit$),$sum$($credit$\_$limit$)$

from employees

WHERE max$($creditlimit$)$ IN $($SELECT sum$($creditlimit$)$

group by manager$\_$id

order by manager$\_$id ;

select manager$\_$id$,$ max$($credit$\_$limit$),$sum$($credit$\_$limit$)$

from employees

group by manager$\_$id

HAVING max$($creditlimit$)$ IN $($SELECT sum$($creditlimit$)$

order by manager$\_$id ;

select manager$\_$id$,$ max$($credit$\_$limit$),$sum$($credit$\_$limit$)$

from employees

group by manager$\_$id

order by manager$\_$id ;

select manager$\_$id$,$ max$($credit$\_$limit$),$sum$($credit$\_$limit$)$

from employees

group by manager$\_$id

order by manager$\_$id

WHERE max$($creditlimit$)$ IN $($SELECT sum$($creditlimit$)$;