Answered step by step
Verified Expert Solution
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
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
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