STUDENTS table contents

ADVISORS table contents

1. Write a SQL statement to display all female students being advised by someone in the Computing Science Department. Use a subquery.

2. Write a SQL statement to display the FirstName and LastName of all students being advised by someone whose FirstName is 'Dave' and LastName is 'Houston'. Use a subquery.

3. Write a SQL statement to display a count of all male students being advised by someone in the 'Physics & Mathematics' Department. Name the count whatever you want. Use a subquery.

4. Write a SQL statement to display the FirstName and LastName of all advisors, and a count of all students being advised by each advisor. Name the count StudentCount. Display only the advisors who counsel more than two students. Use a join.

5. Write a SQL statement to display the FirstName and LastName of all advisors who currently advise no students. Use NOT IN and subquery.

6. Write a SQL statement to display the FirstName and LastName of all students being advised by someone in the 'Computing Science', 'Information Technology', and 'Information Science' Departments. Use a subquery.

7. Write a SQL statement to display the FirstName and LastName of all students being advised by someone not in the "Computing Science", "Information Technology", "Information Science" and "Biology" Departments. Sort the results in ascending order by LastName. Use a subquery.

8. Write a SQL statement to display the FirstName and LastName of all students being advised by someone whose FirstName is 'Dave' and LastName is 'Houston'. Use a join.

9. Write a SQL statement to show the Department and average GPA of all students in each department. Use a join.

10. Write a SQL statement to show the FirstName and LastName of all advisors and a count of all female students being advised by each advisor. Use a join.

11. Show the FirstName and LastName of all advisors who have a student with a GPA greater than or equal to 3.78. Use a subquery. Presents results sorted by LastName in ascending order and then FirstName is descending order.

12. Write a SQL statement to display all advisors who have a student born after '1999-12-31'. Use a subquery.

Major Standing GPA AdvisorlD