Given two tables: Students(studentid, name, ...) Enrollment(studentid, course, grade) a) Write an SQL query to retrieve all student names, their…

Given two tables:

Students(studentid, name, ...)
Enrollment(studentid, course, grade)

a) Write an SQL query to retrieve all student names, their courses, and grades.

b) Write an SQL query to retrieve names of students who obtained grade 'A'.