Question: Please post the answer in SQL query to be implemented on DB browser SQLITE.. I am mentioning this because I posted the same question before

Please post the answer in SQL query to be implemented on DB browser SQLITE.. I am mentioning this because I posted the same question before but Couldn't get the answer which I wanted.
Table: attendance_events 0 Table: all_students 62 . 0 student_id school_id grade_level date_of_birth hometown Filter Filter Filter Filter Filter 1 110111 205 1 2013-01-10 Pleasanton 2 110115 205 1 2013-03-15 Dublin 3 110119 205 2 2012-02-13 San Ramon 4 110121 3 2011-01-13 Dublin 5 110125 205 2 2012-04-25 Dublin 6 110129 205 3 2011-02-22 San Ramon date_event student_id attendance Filter Filter Filter 1 2018-01-10 110111 present 2 2018-01-10 110121 present 3 2018-01-12 110115 absent 4 2018-01-13 110119 absent 5 2018-01-13 110121 present 6 2018-01-14 110125 present 7 2018-02-05 110111 absent 2018-02-17 110115 present 9 2018-02-22 110129 absent 205 8 Q3). You are given a School. db file. Write an SQL to find out what percent of students attend school on their birthday from attendance_events and all_students tables? If your query executes correctly, you should be getting the following result. Percent 1 22
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
