Consider the following scheme Personal integer, namestring) Observer integer), Meteorologist (nid integer), Consumed integer), Lives At Catedra-string, sit string state string, pid integer.) Forecast fid string, Iugleinfeger, low integer, flate date, city strung), Presents and integer, fid integer). Views (ld integer id inter) Records (and integer id integer, method: string) This represents a subset of the schema that was used in Project! Select a correct Oracle SOL query to count the number of forecasts that meteorologists have presented and tot viewed In order for forecast to be counted, it must have been presented by the meteorologist and that came fort must not have been viewed by that meteorologist List the pid and the count none of these SELON .pid, count (DISTINCT R. fid) AS MUSER_PORECASTS THON on 1. Meteorologist 2. DEORE Views WHERE p.pid Mopid AND m.pid lipid MD 2.pid = V.pad GROUD EX w.pid UBER FORECASTS FROM Person P. Meteorologist M.VE DHENE D.pid - spid AND pdv pid GROUP BY v.id LECT D.pid, COUNT DISTANCE RUSER_TORCATS ROK Pason. Meteorologie WE .id - Mga Dapta CHO Y Papid SELECT a.id, Count DISTINCT. NE DORECASTS THOM DO 2. Metologia Mtants W .id - Dt.id = pid Hipid 10 TI O O.pl FM Views GROUP Previous est Page 4 of 13 Sue mpaq LA2206 Chp me so wrcon 6 Vowencente RE Consider the following scheme Personal integer, namestring) Observer integer), Meteorologist (nid integer), Consumed integer), Lives At Catedra-string, sit string state string, pid integer.) Forecast fid string, Iugleinfeger, low integer, flate date, city strung), Presents and integer, fid integer). Views (ld integer id inter) Records (and integer id integer, method: string) This represents a subset of the schema that was used in Project! Select a correct Oracle SOL query to count the number of forecasts that meteorologists have presented and tot viewed In order for forecast to be counted, it must have been presented by the meteorologist and that came fort must not have been viewed by that meteorologist List the pid and the count none of these SELON .pid, count (DISTINCT R. fid) AS MUSER_PORECASTS THON on 1. Meteorologist 2. DEORE Views WHERE p.pid Mopid AND m.pid lipid MD 2.pid = V.pad GROUD EX w.pid UBER FORECASTS FROM Person P. Meteorologist M.VE DHENE D.pid - spid AND pdv pid GROUP BY v.id LECT D.pid, COUNT DISTANCE RUSER_TORCATS ROK Pason. Meteorologie WE .id - Mga Dapta CHO Y Papid SELECT a.id, Count DISTINCT. NE DORECASTS THOM DO 2. Metologia Mtants W .id - Dt.id = pid Hipid 10 TI O O.pl FM Views GROUP Previous est Page 4 of 13 Sue mpaq LA2206 Chp me so wrcon 6 Vowencente RE