Find all my SQL code here. Syntax may vary depending on the type of RDMS I'm referring to but I will make it clear as to the type being used. SQL syntax variations will include the following: Oracle, MySQL, Microsoft SQL, Maria, SQLite, PostgreSQL and a variety of NOSQL and document oriented databases.
If you have any questions or suggestions send me a message.
Remember, to force a browser cache refresh and reload any page press Ctrl + F5. Or hold down Shift + Reload .
Sub queries with relative comparison operators.
SELECT * FROM score WHERE event_id = (SELECT event_id FROM grade_event WHERE date = '2012-09-23' AND category = 'Q');