Consider the following schema: Person (pid: integer, name: string); Observer (pid: integer); Meteorologist (pid: integer); Consumer (pid: integer); Lives_At (streetAddress: string, city: string, state: string, pid: integer.), Forecast (fid: string, high: integer, low: integer, fdate: date, city: string): Presents (pid: integer, fid: integer): Views (pid: integer, fid: integer): Records (pid: integer, oid: integer, method: string); This represents a subset of the schema that was used in Project 1. Select the description of the following query which most accurately describes the meaning of the query SELECT DISTINCT P.pid, P.name FROM Person P Consumer C, views, Forecast E WHERE c.pid = p.pid AND c.pid = v.pid AND V.fid = F. fid AND F.city IN (SELECT I.city FROM Lives Au I WHERE P.pid = L.pid) List the consumers who have viewed forecasts for cities in which they do not live. List the consumers who have viewed forecasts for cities in which they live. List the people who have viewed forecasts for cities in which they live. List the consumers who have presented forecasts for cities in which they live. none of these