Question1: using functions, present a sql statement to find the month of 2018-11-27;

 

Question 2: present a sql statement to find the dimensions of the dogs with id '7' in uppercase.

 

Question 3: present a sql statement to find the test name of the user with id '22' and print the last 8 letters from right

 

Question 4: present a sql statement to merge gender and breed, please make sure to add "-" in between them as well as gender display uppercase.

 

Question 5: present a sql statement report match if dog gender be 'female' and dimensions be'charmer' otherwise display not match.