Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the tables provided, write an SQL query that returns one row per student with columns for LAST_NAME, FIRST_NAME, GRADE_LEVEL , STUDENT_NUMBER, and the total

Using the tables provided, write an SQL query that returns one row per student with columns for LAST_NAME, FIRST_NAME, GRADE_LEVEL , STUDENT_NUMBER, and the total number of unverified absences from September 1st, 2013 up to and including January 31st, 2014 for students in grades 0 through grade 5.image text in transcribedimage text in transcribed

Table 1: STUDENTS table GRADE_LEVEL LAST_NAME 5 FL 3 Pr 5 Ga 2 FIRST_NAME 3 L D E L STUDENTID 13182 16303 16398 18997 21945 22567 26405 29213 32519 33907 30301 11425 STUDENT_NUMBER 2000571 2001841 2001948 2002880 2003562 2004022 2004955 2006168 2007599 2008443 2006523 2000094 3 Jo 2 Sp 2 Da 2 Mu W SCHOOLID 6090302 6090187 6090302 6090302 6090302 6090302 6090302 6090302 6090302 6090302 131177 131177 . OBL L H F owi o St 10 If 10 SC M Table 2: ATTENDANCE_CODE table ATTENDANCE_CODEID Q ATT_CODE DESCRIPTION 5851 SUS Suspended 5468 T Tardy 5852T Tardy 5867T Tardy 5469 UNV Unverified 5868 UNV Unverified 5853 UNV Unverified 5470 UNX Unexcused 5869 UNX Unexcused 5854 UNX Unexcused 5471 (null) Present 5870 (null) Present E PRESENCE_STATUS_CD SCHOOLID Absent 6090302 Present 131177 Present 6090302 Present 6090187 Absent 131177 Absent 6090187 Absent 6090302 Absent 131177 Absent 6090187 Absent 6090302 Present 131177 Present 6090187 Table 3: ATTENDANCE table ATTENDANCE_CODEID STUDENTIDE ATT_DATE SCHOOLID 5852 29213 12/18/2013 6090302 5853 21945 12/20/2013 6090302 5852 9068 12/10/2013 6090302 5853 9080 12/10/2013 6090302 5853 13182 12/10/2013 6090302 5852 9096 12/18/2013 6090302 5852 16398 12/09/2013 6090302 5852 26405 12/09/2013 6090302 5852 22567 12/09/2013 6090302 5852 31009 12/17/2013 6090302 5852 18997 12/18/2013 6090302 5854 32519 12/20/2013 6090302 5868 9425 12/09/2013 6090187 5852 29213 12/03/2013 6090302

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

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago