1. Use the schoolscheduledb database schema 2. Copy this assignment into a Word

Question

1. Use the schoolscheduledb database schema

2. Copy this assignment into a Word Document and provide the Translation, Cleanup, and SQL that accomplishes the following requirements

-d. “The dean would like to know what the current average class duration is.” Make sure it looks exactly like the example output (at the back of this assignment).

4. Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted. 5. Outputs for each requirement (request) are shown below.

5. Outputs for each requirement (request) are shown below.

Explanation / Answer

Solution:

The schema is not given so I am writing the queries on assumption of the schema, if there is a difference between what you intended to, please let me know in the comments before downvoting:

The dean would like to know what the current average class duration is.

Query:

SELECT AVG(duration) FROM class

Explanation:

Aggregate function AVG() is used to calculate the average of any particular column in the table.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.