Provide select statements to satisfy the following data requests:
- List all active male students assigned to Advisors 1 or 3 (Fred Stone or Jack Simpson).
- Provide a list of all students without a biography.
- What classes are in the English department?
- Create a list of all students and their advisors. Sort by the advisor’s name and then the student’s name. Include the student’s birth date, gender, and GPA.
- How many students were born in the 1980s?
- Write a query to show the average GPA by gender.
- Provide a list of all advisors and the number of active students assigned to each. Filter out any advisors with more than 1 student.
Describe what you did for each step and paste in the actual SQL text used to perform each step.