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;
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;
Step by step
Solved in 2 steps
