Model solution for cw3 This is just one possible
solution, other perfectly valid ones are also possible (for example, the last
two questions can be done without nested queries). One of the most common
mistakes was to use a value which you got from a separate
query as part of another query: for example, use WHERE Actor_id = 21
instead of
WHERE Actor_ID =
(SELECT Actor_ID
FROM nza.Actor
WHERE Name = 'Carrie Fisher')