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, 23.06.2019 00:30, devenybates
Which one of the following is the most accurate definition of technology? a electronic tools that improve functionality b electronic tools that provide entertainment or practical value c any type of tool that serves a practical function d any type of tool that enhances communication
Answers: 1
Computers and Technology, 23.06.2019 12:00, clevelandjaniya1
Which of these is a benefit of using objects in a powerpoint presentation? a. collaborators can create the external files while you create and edit the slide show. b. you can easily change the theme and design of the presentation. c. you can have older data in the source file while having up-to-date data in the presentation. d. collaborators can easily share the presentation.
Answers: 2
Computers and Technology, 24.06.2019 01:30, tanya44737
Hazel has just finished adding pictures to her holiday newsletter. she decides to crop an image. what is cropping an image?
Answers: 1
Create the SQL statements for displaying the results for each of the following scenarios in the Acad...
Biology, 06.07.2021 03:50
Chemistry, 06.07.2021 03:50
Mathematics, 06.07.2021 03:50
World Languages, 06.07.2021 03:50
Biology, 06.07.2021 03:50
Chemistry, 06.07.2021 03:50
Biology, 06.07.2021 03:50
Health, 06.07.2021 03:50