Skip to content

Instantly share code, notes, and snippets.

@neurotech

neurotech/awards.sql

Created September 10, 2014 08:24
Show Gist options
  • Save neurotech/2c991ebb65e3b3c29eeb to your computer and use it in GitHub Desktop.
Save neurotech/2c991ebb65e3b3c29eeb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
awards.sql
SELECT
student_welfare.student_id,
student_welfare.staff_id,
student_welfare.what_happened_id,
student_welfare.class_id,
class.class
FROM student_welfare
INNER JOIN class ON class.class_id = student_welfare.class_id
WHERE date_entered = DATE('2014-09-10') AND student_id = 30144
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment