To answer these questions, I'll assume that you have the following tables: - `movies` with columns `movie_id`, `title`, `release_year`, `director_id` - `directors` with columns `director_id`, `first_name`, `last_name` - `actors` with columns `actor_id`, `first_name`, `last_name` - `roles` with columns `role_id`, `actor_id`, `movie_id`, `role_name` 1. SQL query to find the actors who were cast in the movie 'Annie Hall': ```sql SELECT a.first_name, a.last_name, r.role_name FROM actors a JOIN roles r ON a.actor_id = r.actor_id JOIN movies m ON r.movie_id = m.movie_id WHERE m.title = 'Annie Hall'; ``` 2. SQL query to find the director who directed a movie that casted a role for 'Eyes Wide Shut': ```sql SELECT d.first_name, d.last_name, m.title FROM directors d JOIN movies m ON d.director_id = m.director_id JOIN roles r ON m.movie_id = r.movie_id WHERE r.role_name = 'Eyes Wide Shut'; ``` 3. SQL query to find who directed a movie that casted a role as ‘Sean Maguire’: ```sql SELECT d.first_name, d.last_name, m.title FROM directors d JOIN movies m ON d.director_id = m.director_id JOIN roles r ON m.movie_id = r.movie_id WHERE r.role_name = 'Sean Maguire'; ``` 4. SQL query to find the actors who have not acted in any movie between 1990 and 2000: ```sql SELECT a.first_name, a.last_name, m.title, m.release_year FROM actors a LEFT JOIN roles r ON a.actor_id = r.actor_id LEFT JOIN movies m ON r.movie_id = m.movie_id WHERE m.release_year 2000; ``` Please note that these queries are based on assumptions about your database schema. You may need to adjust them to fit your actual schema.

Question

To answer these questions, I'll assume that you have the following tables:

- `movies` with columns `movie_id`, `title`, `release_year`, `director_id`
- `directors` with columns `director_id`, `first_name`, `last_name`
- `actors` with columns `actor_id`, `first_name`, `last_name`
- `roles` with columns `role_id`, `actor_id`, `movie_id`, `role_name`

1. SQL query to find the actors who were cast in the movie 'Annie Hall':

```sql
SELECT a.first_name, a.last_name, r.role_name
FROM actors a
JOIN roles r ON a.actor_id = r.actor_id
JOIN movies m ON r.movie_id = m.movie_id
WHERE m.title = 'Annie Hall';
```

2. SQL query to find the director who directed a movie that casted a role for 'Eyes Wide Shut':

```sql
SELECT d.first_name, d.last_name, m.title
FROM directors d
JOIN movies m ON d.director_id = m.director_id
JOIN roles r ON m.movie_id = r.movie_id
WHERE r.role_name = 'Eyes Wide Shut';
```

3. SQL query to find who directed a movie that casted a role as ‘Sean Maguire’:

```sql
SELECT d.first_name, d.last_name, m.title
FROM directors d
JOIN movies m ON d.director_id = m.director_id
JOIN roles r ON m.movie_id = r.movie_id
WHERE r.role_name = 'Sean Maguire';
```

4. SQL query to find the actors who have not acted in any movie between 1990 and 2000:

```sql
SELECT a.first_name, a.last_name, m.title, m.release_year
FROM actors a
LEFT JOIN roles r ON a.actor_id = r.actor_id
LEFT JOIN movies m ON r.movie_id = m.movie_id
WHERE m.release_year < 1990 OR m.release_year > 2000;
```

Please note that these queries are based on assumptions about your database schema. You may need to adjust them to fit your actual schema.

Knowee AI · Accepted Answer