Using DB Browser for SQlite queries that will retrieve the relevant information from the database, e$.$g$.$

SELECT A$2.$actor$\_$id$,$ A$2.$first$\_$name, A$2.$last$\_$name, COUNT$(*)$ AS tot FROM actor A$1,$ actor A$2,$ film$\_$actor FA$1,$ film$\_$actor FA$2$

WHERE A$1.$first$\_$name $=$ 'STAN' AND A$1.$last$\_$name $=$ 'LAUREL' AND A$1.$actor$\_$id $=$ FA$1.$actor$\_$id

AND FA$1.$film$\_$id $=$ FA$2.$film$\_$id AND FA$2.$actor$\_$id $=$ A$2.$actor$\_$id AND A$1.$actor$\_$id $<>$ A$2.$actor$\_$id

GROUP BY A$2.$actor$\_$id$,$ A$2.$first$\_$name, A$2.$last$\_$name ORDER BY tot DESC;

Table $1$: The film table provides information about a film. A film is related to language. There are two relationships in the ER diagram, one for an original language the film was recorded in and the other one for the language it is available in$.$ Both relationships are modelled in the table below by means of the corresponding foreign keys.

Table $2$: The category table describes different categories of films.

Table $3$: Each film may belong to multiple categories. This relationship is represented by the

film$\_$category table. Each row of this table links a film to a category.

Questions

$1.$ What is the first name of the customer who lives in the same city as MATTIE HOFFMAN?

$2.$ To find the median, you need to order numbers and find the middle value. What is the median of film cast size?

$3.$ What category of films is most expensive to replace on average? Provide the name of such category.

$4.$ Which country $($from the ones listed in the country table$)$ has no customers?

$5.$ How much money was earned by renting the film HOBBIT ALIEN?

$6.***$ Find all customers who rented a film whose title contains the name of the country they live in$.$ Out of these customers, what is the last name of the customer who returned such movie most recently.

$7.***$ What is the title of the most frequently rented Sports movie in Russian Federation?