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 employeesgroup by manager$\_$idorder by manager$\_$id ;Please select a working SQL:Question $34$ options:

select manager$\_$id$,$ max$($credit$\_$limit$),$sum$($credit$\_$limit$)$from employeesgroup by manager$\_$idHAVING max$($creditlimit$)$ IN $($SELECT sum$($creditlimit$)$order by manager$\_$id

select manager$\_$id$,$ max$($credit$\_$limit$),$sum$($credit$\_$limit$)$from employeesgroup by manager$\_$idorder by manager$\_$id ;

select manager$\_$id$,$ max$($credit$\_$limit$),$sum$($credit$\_$limit$)$from employeesWHERE max$($creditlimit$)$ IN $($SELECT sum$($creditlimit$)$group by manager$\_$idorder by manager$\_$id ;

select manager$\_$id$,$ max$($credit$\_$limit$),$sum$($credit$\_$limit$)$from employeesgroup by manager$\_$idorder by manager$\_$idWHERE max$($creditlimit$)$ IN $($SELECT sum$($creditlimit$)$;