Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_ Queries (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express. Based on data in the Academic Database, complete the following: Write a simple query to view the data inserted in student table created for the Academic Database.
Write a query to retrieve the marks obtained by the student for each test attempted.
The faculty of the different Departments realized that the marks entered in test Results were showing a decreased value of 7 marks for each entry. Display the marks by adding 7 points to the grades obtained by each student.
Display the First Name and Email Address as "The email address of is
".
Display the department name and the HOD of the department from the Department table.
Display the distinct Department ID from the Course table.
Display the course details for the Spring Session (Session ID 100).
Display the details of the students who have scored more than 93.
Display the course details for departments 20 and 30.
Display the details of students whose first name begins with the letter "M".
Display the details of students who have opted for courses 190 or 193.
Display the course details offered by department 30 for the Fall Session (Session ID 200).
SELECT * FROM Student
SELECT grade FROM Student
SELECT 7+grade FROM student;
SELECT CONCAT(" The email address of ",Firstname, " is ", email_id) AS data FROM Students;
SELECT Department_name, HOD_name FROM Department
SELECT DISTINCT Department_Id FROM Course;
SELECT * FROM Course WHERE Session_Id=100;
SELECT * FROM Student WHERE mark>93
SELECT * FROM Course WHERE Department=20 AND Department=30;
SELECT * FROM Student WHERE FirstName LIKE 'M%';
SELECT * FROM Student WHERE Course WHERE Course=190 OR Course=193