Computers and Technology, 08.03.2021 20:10 lilquongohard
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
Answers: 1
Computers and Technology, 22.06.2019 17:00
Which of the following is not contained on the slide show toolbar? a. next button b. slide button c. close button d. pen tool
Answers: 1
Computers and Technology, 23.06.2019 17:00
*! 20 points! *jeff wants to create a website with interactive and dynamic content. which programming language will he use? a. dhtml b. html c. css d. javascript
Answers: 1
Computers and Technology, 23.06.2019 19:30
You can apply several different worksheet themes from which tab?
Answers: 1
Computers and Technology, 24.06.2019 00:40
What is the error in the following pseudocode? module main() call raisetopower(2, 1.5) end module module raisetopower(real value, integer power) declare real result set result = value^power display result end module
Answers: 1
Create the SQL statements for displaying the results for each of the following scenarios in the Acad...
Mathematics, 09.04.2021 21:10
Chemistry, 09.04.2021 21:10
Biology, 09.04.2021 21:10
Mathematics, 09.04.2021 21:10
Social Studies, 09.04.2021 21:10
Mathematics, 09.04.2021 21:10