MySQL Database Questions *ONLY ANSWER IF ANSWERING ALL 5*

Thanks!

QUESTION 12 Complete the four blanks in the following SQL query to retrieve all information from the table Students where age is greater than (or equal to) 18 but less than (or equal to) 25. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces. SELECT FROM WHERE BETWEEN QUESTION 13 Complete the four blanks in the following SQL query to retrieve the productName of products which contain the words pumpkin or potato in their names. Sort the results in descending order. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces. SELECT productName FROM Products WHERE OR productName LIKE ORDER BY QUESTION 14 Complete the two blanks in the following SQL query to retrieve the productiD of products which have a productName that contains the word cheese (or cheeze). Use a regular expression to complete this query. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces SELECT productiD FROM Products WHERE QUESTION 15 Complete the two blanks in the following SQL query to retrieve the productID, productName and salePrice of products that belong to the categories pants or shirts. The salePrice of each product is not stored as an attribute, but is instead calculated by adding 10 percent to the preTaxPrice. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces AS salePrice SELECT productID, productName FROM Products category'Shirts': WHERE category Pants QUESTION 16 Consider the relational algebra expression below (ryirstNamezastName(oage >20(Customers))) u (?,irstName,lastName(oage>20(Employees))) Complete the two blanks in the following SQL query to return the same information as the relational algebra expression above. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces SELECT firstName, lastName FROM Customers WHERE age> 20 SELECT WHERE age 20