I feel like if the instructions explained how to insert the month an year totals, that would bring it down to a true 6.

I'm stuck at the monthly/yearly totals. I can get the daily totals, but dont know how to insert the others.

Many katas have different tests applied to "test" and "attempt."

If you want a random sampling of rows from a table, this is one way to do it. Add a limit statement, and you can see what some rows look like. From my research on the kata: http://www.titov.net/2005/09/21/do-not-use-order-by-rand-or-how-to-get-random-rows-from-table/

The list is all of the students that are accepted into any house.

At first I thought I had dones something wrong when it returned zero rows, but I tested for the Slytherin conditions and there are no students that match.