Question: Question 4 (5 points) Consider the following schema: Person (pid integer, name: string), Observer (nid integer); Meteorologist (pid integer); Consumer (pid: integer), Lives_At (streeldddresa: string,

Question 4 (5 points) Consider the following schema: Person (pid integer, name: string), Observer (nid integer); Meteorologist (pid integer); Consumer (pid: integer), Lives_At (streeldddresa: string, city string, state string, pid integer); Forecast (fid: string, high: integer, low integer, fdate date, city string); Presents (id: integer, fid integer); Views (rid integer, fid integer); Records (pid integer, oid integer, methodi string); This represents a subset of the schema that was used in Project 1 Select a valid Oracle SQL query to list the cities with the forecasts with the lowest low. List the city and the forecast low temperature. select DISTINCT F.city, MIN (Flow) from Forecast select DISTINCT F.city, F.low from Forecast E where Flow IN (select MIN (Flow) from Forecast E); select DISTINCT E.city, F.low from Forecast E where F.low NOT IN (select MAX (F.low) from Forecast E); none of these select DISTINCT F.city, Flow from Forecast E where F.low NOT IN (select MAX (F.high) from Forecast E)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
