Consider the following schema Person (pid integer, name: string). Observer (rid integer), Meteorologist Rid integer); Consumer (pid integer). Lives At (soetAddress string city string, state, string, pid:integer); Forecast (lid string light integer, low:integer, fdate date,city: string); Presents (id integer, fid integer), View Grid integer, fid integer), Records (puld integer old integer, mathod: 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, B.name FROM Person Consumer 0 Views V, Forecas E WHERE c.pid = p.pid AND c.pid - V.pid AND V. fid E. fid AND F.city IN (SELECT L.city EROM Livest WHERE p.pid pid List the consumers who have presented forecasts for cities in which they live Last the people who have viewed forecast for cities in which they live. List the consumers who have viewed forecasts for cities in which they do not live List the consumers who have viewed forecast for cities in which they live none of these Previous Pa Nunct Page Page 5 of 13 mpo LA2206 GA to wrcan cu butube James Centities