[Solved] Mysql query to find out which id is having both french and german

You can use this statement:

SELECT id
FROM st 
where name in ('german','french')
Group by id
having Count(*)=2

You should rename the column id in student_id