please solve part 2 of this question. and please post a new answer and not the one here previously

Marks 2 Part-1/during lab-2/Week-2/day-2 1. Create a database as "your last_name_A1" then crate all tables, and insert all records mentioned above. 2. Rename records into columns StudentName, FacultyName, and CourseName by adding the first letter of your first name at the end of each record. For example, if your first name Joe, then StudentName: Letersky will be Leterskyj, Faculty Name: Collins will be Collinsj, and CounseName: SysAnalysis will be SysAnalysisj 3. Steps 1, 2, and at least one of the following queries must be done and reported to the professor before the end of the lab. 3 Part-2 on or before the due date Write SQL Commends for the following 0.5*6 1. Write SQL commands for the following: a. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to die STUDENT table. b. Now, write a command that will remove this student from the STUDENT table. c. How would your command look like if your task was to remove any student with the last name Lopez from the STUDENT table? d. Create an SQL command that will modify the name of the course ISM 4212 from Database to Introduction to Relational Databases. 2. Write SQL queries to answer the following questions: Which students have an ID number that is less than 50000? b. What is the name of the faculty member whose ID is 4756? a