Consider the full query below:

SELECT mvtitle

FROM movie

WHERE mvnumb NOT IN $($SELECT mvnumb

FROM borrow

WHERE mmbnumb IN $($SELECT mmbnumb

FROM member

GROUP BY mmbnumb

HAVING COUNT$(*)<2))$;

Which can be considered separately as the innermost query:

SELECT mmbnumb

FROM member

GROUP BY mmbnumb

HAVING COUNT$(*)<2$

and the middle subquery:

SELECT mvnumb

FROM borrow

WHERE mmbnumb IN $($SELECT mmbnumb

FROM member

GROUP BY mmbnumb

HAVING COUNT$(*)<2)$

Select all the correct statements below:

The innermost subquery $($SELECT mmbnumb... $)$ returns members who live in more than $2$ cities

The innermost subquery $($SELECT mmbnumb... $)$ returns cities that have more than $2$ members

The middle subquery $($SELECT mvnumb $...)$ returns the movies borrowed by members who live in more than $2$ cities

The middle subquery $($SELECT mvnumb $...)$ returns the movies borrowed by members who live in $2$ or less cities

The middle subquery $($SELECT mvnumb $...)$ returns the movies borrowed by members from cities with more than $2$ members

The middle subquery $($SELECT mvnumb $...)$ returns the movies borrowed by members from cities with $2$ or less members

The full query lists the title of movies borrowed only by members who live in $2$ or more cities

The full query lists the title of movies that have never been borrowed

The full query lists the title of movies borrowed only by members who live in less than $2$ cities $($including movies that have never been borrowed$)$

The full query returns something else $($not listed$)$