Please I need an answer for this problem, I have posted this problem 5 times.Put aggregate without condition for the following 6 queries:Queries:-- Query 1-- Find the details of students who was born after 31st december 2004.select * from Student_Information where DOB>"2004-12-31";-- Query 2-- Find all student details whose first name begins with J.select * from Student_Information where FirstName like 'J%';-- Query 3-- Find the total fees for each FeeID.select FeeID,(OrientationFee+CampusFee+LabFee+CommencementsFee) as "Total Fees" from Fees;-- Query 4-- Find all subject IDs whose Subject1 is botany.select subjectID from Subjects where Subject1="Botany";-- Query 5-- Find all gradeIDs with 10 points for both quiz and exam.select GradeID from Grades where Quizzes=10 and exams=10;-- Query 6-- Find the feeid and orientation fees where orientation fees is beween 500 and 1300select FeeId,OrientationFee from Fees where OrientationFee BETWEEN 500 AND 1300; Schema:Student's InformationFeesSubjectsGradesStudent's Information (ID, Firstname, Lastname, DOB);Fees (ID, Orientationfees, Campusfees, Labfees, Commencementfees);Subjects (ID, Subject1, Subject2, Subject3, Subject4);Grades (ID, Quizzes, Classwork, Homework, Exams, Finalgrade);Student's InformationIDFirstnameLastnameDOBFeesID OrientationfeesCampusfeesLabfeesCommencementfeesSubjectsSubjectnameGradesID QuizzesClassworkHomeworkExamsFinalgrac

An aggregate functions are used to calculate the summary values from the data in a particular…

Answered: Put aggregate without condition for the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

Please I need an answer for this problem, I have posted this problem 5 times.

Put aggregate without condition for the following 6 queries:

Queries:

-- Query 1
-- Find the details of students who was born after 31st december 2004.
select * from Student_Information where DOB>"2004-12-31";

-- Query 2
-- Find all student details whose first name begins with J.
select * from Student_Information where FirstName like 'J%';

-- Query 3
-- Find the total fees for each FeeID.
select FeeID,(OrientationFee+CampusFee+LabFee+CommencementsFee) as "Total Fees" from Fees;

-- Query 4
-- Find all subject IDs whose Subject1 is botany.
select subjectID from Subjects where Subject1="Botany";

-- Query 5
-- Find all gradeIDs with 10 points for both quiz and exam.
select GradeID from Grades where Quizzes=10 and exams=10;

-- Query 6
-- Find the feeid and orientation fees where orientation fees is beween 500 and 1300
select FeeId,OrientationFee from Fees where OrientationFee BETWEEN 500 AND 1300;

Schema:
Student's Information
Fees
Subjects
Grades
Student's Information (ID, Firstname, Lastname, DOB);
Fees (ID, Orientationfees, Campusfees, Labfees, Commencementfees);
Subjects (ID, Subject1, Subject2, Subject3, Subject4);
Grades (ID, Quizzes, Classwork, Homework, Exams, Finalgrade);
Student's Information
ID
Firstname
Lastname
DOB
Fees
ID Orientationfees
Campusfees
Labfees
Commencementfees
Subjects
Subjectname
Grades
ID Quizzes
Classwork
Homework
Exams
Finalgrac

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions