PROVIDE the SQL query that solves the problem
9) List all information for members that are located in TN and have a balance greater than $10. (w3schools -> SQL And & Or)
10) List the title of the movies that are either action or drama. (w3schools -> SQL And & Or)
11) List only those members whose last names start with the letter 'M'. (w3schools -> SQL Like and SQL Wildcards)
12) List all return dates but do not display the column label [Detail_ReturnDate] - instead display a label of 'Returned' (w3schools -> SQL Alias)
13) Return the total of rent fee and daily late fee AS TOTALoneDayLate for every price code (w3schools -> SQL Alias)
14) List all video numbers for movie numbers 1235, 1237 and 1245 - use the IN keyword (w3schools -> IN)
15) List the member number for all members who rented a video on March 2, 2018. {Working with dates can be very tricky. In this database, the date datatype is simple – month -day-year. In Oracle, you will search using this format: ‘dd-mmm-yyyy’ quote marks required: = ‘02-Mar-2018’ In Access, you use the # key: = #02-Mar-2018# {Access will also allow #3/2/2018#}}