Consider the following schema: Person (pid integer, name: string); Observer (nid integer). Meteorologist (pid integer); Consumer (pid integer), Lives At (streetdddresa: string, city string state: string, pid integer.). Forecast (fid string, high integer, low:integer, fdate, date, city string); Presents (id: integer, fid integer). Views (idinteger id integer): Records (pid integer, ordinteger, method. string). This represents a subset of the schema that was used in Project 1 Select the valid Oracle SQL query to list the observers who recorded more than 5 observations. For each observer you are to list the name of the observer, the pid value and the count of the number of observations SELEOT R.pd, P.name. COUNT (DISTINCT R.bid) FROM records B, Person P WHERE R.pid = p.pid GROUP BY R.pid, P.Tame HAVING (COUNT (DISTINCT Rody > S) SELECT R.pid, P.name. COUNT (DISTINCT B.id EROX Tecords Person GROUP BY R.pid, P.name HAVING COUNT (R.id) >5 SELECT R.pid, Pinamo. COUNT (DISTINO R010) FROM records Ry Person WHERE R.pid - P.pid AND COUNT (DISTINCT Roas GROUP BY R.pid, Potamo none of these SELECT .pid, Pan COUNE DISTINCT 10 TROS YOcords) Pornon WHERE R.pid - Pupid GROUP BY b.id HAVING COUNT DESTINCT Rod) > 51 Previous Page Nest Page Page 3 of 13 hp 206% VALUES A trave no wrean dritentes vames Centries