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