Question
Based on the data given (shown below) for the Academic Database, complete the following: Write a simple query to view the data inserted in at
Based on the data given (shown below) for the Academic Database, complete the following:
Write a simple query to view the data inserted in at least one of the tables created for the Academic Database.
Write a query to retrieve the marks obtained by the student for each exam attempted.
Retrieve the student ID and first name for each student are concatenated with the literal ":" (colon).
The faculty of the different Departments realized that the marks entered in Exam Results were showing an increased value of 5 marks for each entry. Display the marks by subtracting 5 marks from the marks obtained by each student.
Display the percentage of days students have taken off and their eligibility for taking the exams.
Display the First Name and Email Address as "The email address of
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.
Display the details of the students who have scored more than 97.
Display the details of the students who have scored between 65 and 70.
Display the students who registered after 01-Jun-2012.
Display the course details for departments 10 and 30.
Display the details of students whose first name begins with the letter "J".
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).
Display the course details of courses not being offered in the summer and fall session (Session ID 200 and 300).
Display the records in ascending order for Exam Results ordered by Student ID and Course ID.
Display the percentage of days students have taken off and sort the records based on the percentage calculated.
Display the top 5 students.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started