1. What would be the code to erase student Lopez from the table (you can type it here in Word)?
2. What would be the code to show the students who have a 2 in their StudentID (you can type it here in Word)?
3. What would be the code for showing the students whose name does NOT start with an A? Please use a NOT operator in your code (you can type the code here in Word).

Use only standard SQL

STUDENT (StudentID, StudentName) QUALIFIED (FacultyID, CourselD, DateQualified) StudentID StudentName FacultyID CourselD Date Qualified 38214 54907 66324 70542 Letersky Altvater Aiken Marra 2143 2143 3467 3467 4756 4756 ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 9/1988 9/1988 9/1995 9/1996 9/1991 9/1991 FACULTY (FacultyID, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID FacultyName Section No Semester CourselD 2143 3467 4756 Birkin Berndt Collins 2712 2713 2714 2715 1-2008 1-2008 1-2008 1-2008 ISM 3113 ISM 3113 ISM 4212 ISM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentID, Section No, Semester) CourselD CourseName StudentID Section No Semester ISM 3113 ISM 3112 ISM 4212 ISM 4930 Syst Analysis Syst Design Database Networking 38214 54907 54907 66324 2714 2714 2715 2713 1-2008 1-2008 1-2008 1-2008