Having the following table structure (see image). Write MYSQL for: (4) Which students (student first name, student last name) have taken the course “Database  Systems”?   (5) List all students (student first name, student last name) who have taken both “Database  Systems” and “C++”.   (6) List all students (student ID, student first Name, student last Name) and the courses (course  name, course grade) that they have taken. If there are students who have not taken any  course yet, the query result should reflect that (i.e. null for courseName, null for grade).   (7) Find all students who have taken computer science courses (i.e. course codes CS***). For the  result, list student first name, student last name, and the computer science course names  that they have taken.

Having the following table structure (see image). Write MYSQL for:

(4) Which students (student first name, student last name) have taken the course “Database 
Systems”?  
(5) List all students (student first name, student last name) who have taken both “Database 
Systems” and “C++”.  
(6) List all students (student ID, student first Name, student last Name) and the courses (course 
name, course grade) that they have taken. If there are students who have not taken any 
course yet, the query result should reflect that (i.e. null for courseName, null for grade).  
(7) Find all students who have taken computer science courses (i.e. course codes CS***). For the 
result, list student first name, student last name, and the computer science course names 
that they have taken.