Please submit those queries into sakai website as soon as possible, so that you can get chance to receive feedback before deadline. After the deadline, we will check the assignment automatically by a script and then given your grade, at that time, any argument about your grade of this assignment will not be accepted.
Single table query
- List the non-US movies released in 1991 and with titles begin with “The” .
- How many actors have acted more than 30 movies.
- What is the percentage of American films in all films in the 1970s. (The result should be expressed percentage and approximated to 2 decimal places )
Multiple table query
- List the names of the known directors of 2016 films by ascending order (no need to display anything about the film). The film only from following regions: kr, hk, gb, ph. If the film is Korean(kr) or HONG KONG(hk), the name should be displayed as surname followed by first name, otherwise it must be first name followed by surname.
only known by one name have a null row returned for them. use surname and first name.
- List all films made after 2000 (including 2000) with the max number of actors borned after 2000 (including 2000).
you can use subquery factoring: with … as (…)
The result set would be multiple rows if more than one films have max number of actors
- List the number of different actors who have been played in the same movie with Yifei Liu (Yife herself is not included).
