Check below code and select below optionsselect count(film_id) from filmwhere count(film_id) > 20a.Correctly working on Sakilab.Query is invalid c.None

What is the issue with the below queryselect* from film_actor having actor_id=10a.None from the provided optionsb.Having will not with out where clausec.Produce result with Incorrect Valuesd.Produce Result with correct valuese.

Modify the query with the following specifications:a. ‘Title’: Grouped by.b. ‘SeatNumber’: Count.c. Only display data from the ‘Movie’ and ‘CountOfSeatNumber’ fields. If you run thequery, it should look like this

List titles of films with 10 or more actors playing the act. Sort the output on descending order of actors per film.will the below query will provide you the correct result SELECT  title as Film_Name, count(actor_id) as Total_ActorsFROM filmINNER JOINfilm_actorONfilm.film_id=film_actor.film_idGroup by  film.film_idhaving  Total_Actors > 9ORDER BYTotal_Actors DESC, titlea.Trueb.False

Write SQL query considering below schema of databaseFilm(film_id, title, legth, rental_rate), Actor(film_id, actor_id, first_name, last_name)Category(film_id, rating, language, release_year)Create tables with Primary Key, foreign key constraints in given schemas.i.Give the name of actors whose actor id is 23.ii.Give the title of films whose id is between 25 and 40.iii.Give the name of actor whose last name contains Kapoor.iv.Give the title of film which was released in 2022.v.Give the name of actors played who have role in film title ‘Chhello divas’

The output of the COUNT() function is the number of rows or column values that would be selected by the query.Question 4Select one:TrueFalse