Which department has the highest amount of students?
select dept_name from student group by dept_name order by count ( * ) desc limit 1
Sure.
select sum ( tot_cred ) from student where dept_name = "Civil eng."
please
select id from student where dept_name = "Civil eng."