1. SELECT COUNT(movie.m_d_id) AS Anzahl, director.d_name, director.d_firstname 
FROM movie, director 
WHERE movie.m_d_id = director.d_id 
GROUP BY movie.m_d_id 
ORDER BY Anzahl DESC 

2. SELECT COUNT(movie.m_d_id) AS Anzahl, director.d_name, director.d_firstname 
FROM movie, director 
WHERE movie.m_d_id = director.d_id 
GROUP BY movie.m_d_id 
ORDER BY Anzahl ASC 

3. SELECT actor.a_name, actor.a_firstname, COUNT(cast.c_a_id) AS Filmbeteiligungen 
FROM actor, cast 
WHERE cast.c_a_id=actor.a_id 
GROUP BY cast.c_a_id 
HAVING Filmbeteiligungen >= 2 

4. SELECT genre.g_name, SEC_TO_TIME(SUM(TIME_TO_SEC(movie.m_duration))) AS Dauer 
FROM genre, movie 
WHERE movie.m_g_id = genre.g_id 
GROUP BY genre.g_name
ORDER BY Dauer DESC
