Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

image text in transcribed

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 teacher

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro SQL Server Wait Statistics

Authors: Enrico Van De Laar

1st Edition

1484211391, 9781484211397

More Books

Students also viewed these Databases questions

Question

What is Change Control and how does it operate?

Answered: 1 week ago

Question

How do Data Requirements relate to Functional Requirements?

Answered: 1 week ago