i. To get the name of actors whose actor id is 23, you can use the following SQL query:

```sql
SELECT first_name, last_name
FROM Actor
WHERE actor_id = 23;
```

ii. To get the title of films whose id is between 25 and 40, you can use the following SQL query:

```sql
SELECT title
FROM Film
WHERE film_id BETWEEN 25 AND 40;
```

iii. To get the name of actor whose last name contains Kapoor, you can use the following SQL query:

```sql
SELECT first_name, last_name
FROM Actor
WHERE last_name LIKE '%Kapoor%';
```

iv. To get the title of film which was released in 2022, you can use the following SQL query:

```sql
SELECT title
FROM Film
JOIN Category ON Film.film_id = Category.film_id
WHERE release_year = 2022;
```

v. To get the name of actors who have role in film title ‘Chhello divas’, you can use the following SQL query:

```sql
SELECT Actor.first_name, Actor.last_name
FROM Actor
JOIN Film ON Actor.film_id = Film.film_id
WHERE Film.title = 'Chhello divas';
```

Please note that the creation of tables with Primary Key, foreign key constraints in given schemas is not included in the above queries. You would need to create the tables first before you can run these queries.

Question

i. To get the name of actors whose actor id is 23, you can use the following SQL query:

```sql
SELECT first_name, last_name 
FROM Actor 
WHERE actor_id = 23;
```

ii. To get the title of films whose id is between 25 and 40, you can use the following SQL query:

```sql
SELECT title 
FROM Film 
WHERE film_id BETWEEN 25 AND 40;
```

iii. To get the name of actor whose last name contains Kapoor, you can use the following SQL query:

```sql
SELECT first_name, last_name 
FROM Actor 
WHERE last_name LIKE '%Kapoor%';
```

iv. To get the title of film which was released in 2022, you can use the following SQL query:

```sql
SELECT title 
FROM Film 
JOIN Category ON Film.film_id = Category.film_id 
WHERE release_year = 2022;
```

v. To get the name of actors who have role in film title ‘Chhello divas’, you can use the following SQL query:

```sql
SELECT Actor.first_name, Actor.last_name 
FROM Actor 
JOIN Film ON Actor.film_id = Film.film_id 
WHERE Film.title = 'Chhello divas';
```

Please note that the creation of tables with Primary Key, foreign key constraints in given schemas is not included in the above queries. You would need to create the tables first before you can run these queries.

Knowee AI · Accepted Answer