On no more than one page using the database, write SQL statements for the following queries. Include the SQL statements. Information regarding the ERD diagram is attached below.

For each pair of faculty with the same rank, display their full names (FFNAME and FLNAME) and FRANKID.

For each pair of faculty members with the same rank, display their full names (FFNAME and FLNAME), FRANKID and the number of sections each faculty member teaches.

Create a new table with the name GRADE_VALUE which stores the letter grades and their corresponding numeric values. Thats, it should look like the following (Name the attributes as shown).

For each student, display the SID and his/her GPA.

STUDENT ENROLLMENT COURSE SECTION COURSE CSECID SLNAME CSECID GRADE CALLID CNAME CCREDIT SECNUM SPHONE MAXENRL FACULTY CURRENRL TERM FID TERMID TDESC STATUS LOCATION 1LOCID FRANK FACULTYIMAGE FRANKID FRANKDESC BLDG CODE ROOM CAPACITY