SQL T3

2. Give the title of film whose length is greater then 180 and rating is 'R' and consist 'Home' word with in
4. Give the name of film starting from G having replacement cost greater then 27 and its length is greater then film id 820
10. Give the rating name which is having 223 movies listed with in ____ rating
12. Give the name of customer whose rental id is 5
16. Give the name of film consist of 'Ali' word and not include ids 13,14,15,223
17. Give the city name of customer whose first name is Dorothy
20. Give the first name of customers whose address consist word 'Shivapuri'
22. Give the title of film whose replacment cost is less then 20 and having 3rd and 5th letter is r with 7th letter t
23. Give the name of film consist of 'Lion' word and its id between 200 and 250
24. Give the name of film which is rented 33 times

1. give the title whose rental id is 5
3. Ark Give the title of film whose id is greater then 999
5. Give the First name of the customer whose id is 5
6. Give the title of film which contains Win in the title and does not having ID=977
7. Give the name of district for which address containts 1411
8. Give the last name of customer whose id is less then 2
9. Give the title of film rented by customer from gujarat and its title consist of 'Impossible' in title
11. Count the total number of films which posses 'A' with in title
13. Give the first name of customer whose phone number contains 03338
14. Give the name of district from where 10 different customers address saved
15. Give the name of customer whose payment Id is 18962
18. last name of actor starts with m and first name is of 2 letters give his first name
19. Give the first name of customer who have rented highest number of films
21. Give the title of film whose film_id is between 10 and 50 and its rating might be any of NC-17,PG-13,R and its length is less then 50