How to use OR, AND, BETWEEN, NOT, IN, and LIKE (including how to use the wildcard symbol '%',)

Using your MYSQL workbench, please write queries to address the following:

• I want to see all data where admission rate is below 20% OR the 4 year grad rate is below 70%
• I want the names of all colleges where the first letter of the college starts with 'c', and the last letter of the college is 'y'. (Hint: Text functions from excel usually work in mysql)
• I want to see all data where the student faculty ratio is between 4 and 8
• I want to see the school, state, and quality rank where the quality rank is above 10 only for the following states: "TX", "MA", "PA", "GA", "NY", and "CA" (hint: we would use IN to achieve this 2nd requirement).
• I want to the count of all schools that have the word "university" in the school name that are not int he state of CA. (hint: we would use LIKE, and we would also use NOT here). Please provide both the SQL syntax and explanation