Notes

/*
UN ID = 18413710
WEEK - 8
ACTIVITY - 8
*/

--query to know the instructor name who have folloing salary
SELECT instructor_name, salary
FROM instructors
WHERE salary IN(2000,2500,3000);

--query using like
SELECT instructor_name
FROM instructors
WHERE instructor_name LIKE 'S%';

--query using between
SELECT instructor_name
FROM instructors
WHERE salary
BETWEEN 2000
AND 2999;

--command to list all table
SELECT * FROM TAB;

--query to count number of student attending the course
SELECT student_id, COUNT(evaluation)
FROM attendance
GROUP BY student_id;

--query to count number of student attending the course where student_id is greater than 6000
SELECT student_id, COUNT(evaluation)
FROM attendance
GROUP BY student_id
HAVING student_id > 6000;

--query to count number of student attending the course where average evaluation is greater or equal to four
SELECT student_id, COUNT(evaluation)
FROM attendance
GROUP BY student_id
HAVING AVG(evaluation)>=4;

--query to calculate the total amount paid by the students
SELECT student_id, SUM(amount_paid)
FROM attendance
GROUP BY student_id
ORDER BY 2;
--7990

--query to the total amount paide for each offering
SELECT offering_id, SUM(amount_paid)
FROM attendance
GROUP BY offering_id
ORDER BY 2;
--1004 5985
--query to display minimum maximum and average evaluation for course offerings
SELECT offering_id,evaluation, MIN(evaluation),MAX(evaluation),AVG(evaluation)
FROM attendance
GROUP BY offering_id
HAVING MIN(evaluation)<2.5;