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 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 or use the query designer to help you). Notes: - CurrentGradeLevel is student's current grade (012). - 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.04.3 ( F thru A+ ) - Academic year is in form like "2022/23" 23. [5pts] Write a SQL SELECT query to answer the following: Which students at "Baton Rouge Magnet High" are enrolled in less than 3 courses in the 2022/23 academic year? Provide the student names and id in the output, sorted AZ by lastname, firstname. 24. [5pts] Write the SQL SELECT query to determine which date had the most student absences in November 2022 (only that date should be selected)

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

Harness The Power Of Big Data The IBM Big Data Platform

Authors: Paul Zikopoulos, David Corrigan James Giles Thomas Deutsch Krishnan Parasuraman Dirk DeRoos Paul Zikopoulos

1st Edition

0071808183, 9780071808187

More Books

Students also viewed these Databases questions

Question

Why is the System Build Process an iterative process?

Answered: 1 week ago