SQL QUERY QUESTIONS (5 PTS EACH) tbl Faculty facultyID facultyName tbl_Weather cityID cityName temperature condition tbl Persons personID firstName lastName tbl_Course_Section courselD courseName facultyID semester year department DOH title DOB Using the tables defined above, write the SQL queries for the questions below: 1. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy. 2. With SQL, how can you return all the records from a table named Persons" sorted descending by FirstName"? 3. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70. 4. List the faculty and the courses they are teaching 5. Find the city with the highest temperature recorded 6. Find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester? 7. Show how many cities have temperatures greater than 50 and sunny conditions