I am working on a query to identify the last time a student submitted an assignment. I use the ATTEMPT table fairly heavily, but have discovered that if an instructor enters a grade of 0 for a non-submitted discussion thread, that gets recorded as an attempt with a grade of 0. When it is an assignment (other than a discussion) there is no attempt record created so it is not an issue for those.
Ultimately I need to know when the student last submitted something. Does anyone have a query that might help with this problem?