Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I want to SQL command all of the Questions (1 - 14) please ! So I put the TABLE and simpling example and the Questions.
I want to SQL command all of the Questions (1 - 14) please ! So I put the TABLE and simpling example and the Questions.
Retrieving data from a single table 1. What is the average of all teacher alaries? 2. How many students are there? 3. List the number of students enrolled in each course. 4. List the number of courses taken by students. 5. List the average grade and number of courses taken by students with an average grade of more than 2.5. Retrieving data from several tables 6. Which teachers teach which courses? (List the teachers by name). 7. List the grades received by each student. 8. Assuming that tuition is S500.00 per course, what is Carol Dean's total tuition bill? 9. For each department, list its courses and setions together with the number of students in each . (Use aliases). 10. List the names of all teachers, along with the names and numbers of the courses taught by each. 11. Which courses did any female student get an A?(list both the courses and the students by name.) 12. Produce a list of the names and addresses of Dr. Horn's students Order the list alphabetically by student name. 13. Produce a roster for each course by teacher, listing the courses and sections they teach along with the names of all students enrolled in each. 14. What is the total number of students taught by each teacherStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started