Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For problems 23-26, write the required SQL SELECT query (either for SQL Server or Access will be accepted) based on the following ERD. Submit the

image text in transcribedimage text in transcribed

For problems 23-26, write the required SQL SELECT query (either for SQL Server or Access will be accepted) based on the following ERD. Submit the SQL in your solution document. You do not have to implement the database (unless you want to test the correctness of your queries of use the query designer to help you). Notes: - CurrentGradeLevel is student's current grade (0-12). - CurriculumCategory: Math, Science, English, Social Studies, Language, Other - Advanced? Yes if an AP, IB, or other advanced level course - Active? Yes if student still attending courses at a district school. - Assume teacherid is unique in the school district. - YTDabsences is academic year absences year to date (August to July) - Course grade earned are values from 0.0-4.3 (F thru A+) - Academic year is in form like "2022/23" 25. [6pts] Write the SQL SELECT query to return a report of each student's GPA and earned credit for the 2021/22 academic year (note: credit is only earned for a course if they have a D(1.0) or higher in the course). Include student's id and name. Sort by GPA in descending order. 26. [6pts] Write the SQL SELECT query to determine which math teacher has given the most F grades in the school's recorded history (at least the history in the database). List the teacher id and number of F grades

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

Data Management Databases And Organizations

Authors: Richard T. Watson

3rd Edition

0471418455, 978-0471418450

More Books

Students also viewed these Databases questions