Write an SQL query that shows the following:

1. Film name and language
2. Film name and actor id (film/title and film_actor/actor_id)
3. Film name and actor name (first name and last name together)
4. Same as above but film name only once with actor names following
5. Actor name and films they appeared in (search by name)
6. Same as above aggregated with GROUP_CONCAT
7. Countries and their cities
8. Add Finland
9. Show also countries that have no cities
10. Show cities that are in the same country as Hanoi
11. What films has Penelope Guiness appeared in
    WITH JOIN
    SAME with subquery
12. List categories of films where Penelope Guiness has appeared
13. Film name and category where Penelope Guiness has appeared
14. Horror films where Penelope Guiness has appeared
15. Horror and family films where Penelope Guiness has appeared