DB chapter three

1. For each student who has retaken a course at least twice (i.e., the student has taken the course at least three times), show the course ID and the students ID. Please display your results in order of course ID and do not display duplicate rows.

2. Find the names of Biology students who have taken at least 3 Accounting courses.

3. Find out the ID and salary of the instructors.

4. Find out the ID and salary of the instructor who gets more than $85,000.

5. Find out the department names and their budget at the university.

6. List out the names of the instructors from Computer Science who have more than $70,000.

7. For all instructors in the university who have taught some course, find their names and the course ID of all courses they taught.

8. Find the names of all instructors whose salary is greater than at least one instructor in the Biology

9. Find the advisor of the student with ID 12345

10. Find the average salary of all instructors.

11. Find the names of all departments whose building name includes the substring Watson

12. Find the names of instructors with salary amounts between $90,000and$100,000.

13. Find the instructor names and the courses they taught for all instructors in the Biology department who have taught some course.

14. Find the courses taught in Fall-2009 semester.

15. Find the set of all courses taught either in Fall-2009 or in Spring-2010.

16. Find the set of all courses taught in the Fall-2009 as well as in Spring-2010.

17. Find all courses taught in the Fall-2009 semester but not in the Spring-2010 semester.

18. Find all instructors who appear in the instructor relation with null values for salary.

19. Find the average salary of instructors in the Finance department.

20. Find the total number of instructors who teach a course in the Spring-2010 semester.

21. Find the average salary in each department.

22. Find the number of instructors in each department who teach a course in the Spring-2010 semester.

23. List out the departments where the average salary of the instructors is more than $42,000.

24. For each course section offered in 2009, find the average total credits (tot cred) of all students enrolled in the section, if the section had at least 2 students.

25. Find all the courses taught in both the Fall-2009 and Spring-2010 semesters.

26. Find all the courses taught in the Fall-2009 semester but not in the Spring-2010 semester.

27. Select the names of instructors whose names are neither Mozart nor Einstein

28. Find the total number of (distinct) students who have taken course sections taught by the instructor with ID 110011.

29. Find the ID and names of all instructors whose salary is greater than at least one instructor in the History department.

30. Find the names of all instructors that have a salary value greater than that of each instructor in the Biology department.

31. Find the departments that have the highest average salary.

32. Find all courses taught in both the Fall 2009 semester and in the Spring-2010 semester.

33. Find all students who have taken all the courses offered in the Biology department.

34. Find all courses that were offered at most once in 2009.

35. Find all courses that were offered at least twice in 2009.

36. Find the average instructors salaries of those departments where the average salary is greater than $42,000.

37. Find the maximum across all departments of the total salary at each department.

38. List all departments along with the number of instructors in each department.

39. Find the titles of courses in the Comp. Sci. department that has 3 credits.

40. Find the IDs of all students who were taught by an instructor named Einstein; make sure there

41. Find the highest salary of any instructor.

42. Find all instructors earning the highest salary (there may be more than one with the same salary).

43. Find the enrollment of each section that was offered in Autumn-2009.

44. Find the maximum enrollment, across all sections, in Autumn-2009.

45. Find the salaries after the following operation: Increase the salary of each instructor in the

46. Find all students who have not taken a course.

47. List all course sections offered by the Physics department in the Fall-2009 semester, with the building and room number of each section.

48. Find the student names who take courses in Spring-2010 semester at Watson Building.

49. List the students who take courses teaches by Brandt

50. Find out the average salary of the instructor in each department.

51. Find the number of students who take the course titled ‘Intro. To Computer Science’

52. Find out the total salary of the instructors of the Computer Science department who take a course(s) In Watson building.

53. Find out the course titles which starts between 10:00 to 12:00.

54. List the course names where CS-101 is the pre-requisite course.

55. List the student names who get more than B+ grades in their respective courses.

56. Find the student who takes the maximum credit from each department.

57. Find out the student ID and grades who take a course(s) in Spring-2009 semester.

58. Find the building(s) where the student takes the course titled Image Processing

59. Find the room no. and the building where the student from Fall-2009 semester can take a course(s)