Consider a DB schema consisting of the following relation schemes: Station (Station_ID, City, State, Lat_N, Long_w) Statistics (Statistic_ID_forastation, Month. Temp, Rain) Now, express the following queries in SOL: 1. Give details of Northern stations (Northern latitude > 39.7): 2. Query to look at the table Statistics, ordered by month and greatest rainfall, with columns rearranged. 3. Write a Query to look at temperatures for July from Statistics, lowest temperatures first, picking up city name and latitude. 4. Write a query to show MAX and MIN temperatures as well as average rainfall for each station. 5. List of stations with year-round average temperature above 50 degrees. 6. Create a view (derived table or persistent query) to convert Fahrenheit to Celsius and inches to centimeters