How many courses are there?
select count ( * ) from course
How many courses are in Mech. eng?
select count ( * ) from course where dept_name = 'Mech. eng.'
Out of those 12 how many of them are more than 3 credits?
select count ( * ) from course where dept_name = 'Mech. eng.' and credits > 3
Yes are there any courses "same title" in the list that are offered by more than one department?
select distinct ( dept_name ) from course where title in ( select title from course where dept_name = 'Mech. eng.' and credits > 3 ) and dept_name ! = 'Mech. eng.'
How many of those courses are there?
select count ( * ) from course where title in ( select title from course where dept_name = 'Mech. eng.' and credits > 3 ) and dept_name ! = 'Mech. eng.'