Consider the following schema: Person (pid: integer, name: string). Observer (pid integer); Meteorologist (pid: integer): Consumer (pid: integer); Lives_At (street Address 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 V Forecast E WHERE c.pid P.pid AND c.pid = V.pid AND V. fid = F. fid AND F.city IN (SELECT L.city FROM Lives At L WHERE p.pid = L.pid) List the consumers who have viewed forecasts for cities in which they live. List the consumers who have presented 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 viewed forecasts for cities in which they do not live. none of these