SQL T3

Edit Answers
123456789101112131415161718192021222324
Across
  1. 3. give the first name of the customer who have rented film least times [Lvl. 3]
  2. 4. Give the first name of customer who have paid highest amount [Lvl. 3]
  3. 7. Give the first name of the actor who collected maximum payment [Lvl. 3]
  4. 8. Give the name of country which is having total 31 customer [Lvl. 3]
  5. 11. Give the first name of the Customer whose address id is less than 10 and last name consist of 'Jonh'[Lvl. 1]
  6. 12. Give the name of Country whose id is greater than 45 and starts with I and having total 5 letters.[Lvl. 2]
  7. 14. Give the name of film whose id is 151[Lvl. 1]
  8. 15. Customers of which country paid highest total amount for renting the film [Lvl. 3]
  9. 17. Give the title of film starts with 'J' and in a list of highest times rented film [Lvl. 3]
  10. 18. Give the title of film whose average of amount is highest [Lvl. 3]
  11. 19. Give the first name of the actor whose id is neither 5 nor 100 and last name exactly having 4 letters starts with 'H' and second last letter is 'r'[Lvl. 2]
  12. 20. Give the first name of actor who have done least number of film [Lvl. 3]
  13. 22. Give the name of film whose rental rate is not greater than 1 and title name ends with 'Theory'[Lvl. 1]
  14. 23. Give the name of film whose id is between 100 and 200 and title consist of 'Duck'[Lvl. 1]
Down
  1. 1. Give the name of film who have collected highest payment [Lvl. 3]
  2. 2. Give the first name of the customer who have paid total amount of 92.81 for film [Lvl. 3]
  3. 5. Which country has listed maximum cities in DVDrental[Lvl. 3]
  4. 6. Give the title of the film who have total collection of 191.74 [Lvl. 3]
  5. 9. Give the name of film whose length is 57 and film id is multiple of 3 up to 18.[Lvl. 1]
  6. 10. Give the name of city which consist of 'nagar' in it name and city id between 50 and 100[Lvl. 1]
  7. 13. Give the name of city starts from 'L' and having 2 customers belongs to that city [Lvl. 3]
  8. 16. Give the last name of the actor whose id is not greater than 5 and first name is of 2 letters[Lvl. 2]
  9. 21. Customer of which city paid least total amount for renting film [Lvl. 3]
  10. 24. Give the first name of the actor who has done 54 films and name starts with 'L' [Lvl. 3]