daot sa vodka ug gin hehehe

ahahahah....

2.SELECT * FROM Lectures WHERE Pay > 31800 AND Pay < 40900;

4. SELECT * FROM Subjects WHERE Credits=1 And PassingMark>70;

5. SELECT DepartmentName, count(StudentID) AS [Number of Students] FROM Departments, Students

WHERE Departments.DepartmentID = Students.DepartmentID GROUP BY DepartmentName;

6. SELECT DepartmentName, sum(Pay) AS [Total Expenditure] FROM Departments, Lectures

WHERE Departments.DepartmentID = Lectures.DepartmentID GROUP BY DepartmentName;

unsaon pag waLa sa dollar sign sir???

7. SELECT FIRST(Joined) AS [Earliest joined the staff] FROM Lectures;

8. SELECT Surname &','& FirstName AS Name, avg(Mark) AS [Average Mark] FROM Students, Exams

WHERE Students.StudentID = Exams.SudentID GROUP BY Surname &','& FirstName;

sir naa ka number 8

9. SELECT DepartmentName, MAPassingMark) FROM Departments, Subjects\

WHERE Departments.DepartmentID = Subjects.DepartmentID GROUP BY DepartmentName;

MAPassingMark) na hap,kanang naay smily icon

ahhhhhh.

MAX (PassingMark) nah

josephjralbano: seph surender nko dli na nko kaya.hehehe. nagsakit ako ulo ani

10. SELECT Surname &', '& FirstName, avg(Mark) AS [Average greater than 56] FROM Students, Exams

WHERE Students.StudentID = Exams.SudentID AND Mark > 56 GROUP BY Surname &', '& FirstName;

11. SELECT Surname &', '& Initial AS [Name], SubjectName FROM Subjects, Lectures WHERE Subjects.SubjectID = Lectures.SubjectID;

1. SELECT Surname FROM Students WHERE Surname BETWEEN 'm*' AND 'z*';

hahai

ife

3. SELECT * FROM Subjects WHERE SubjectName IN ('Physiology', 'Anatomy');

josephjralbano: Sir,thnk u kaau ha?hope dili ka mgsawa sa amo hehehehe