OP solved it, closing

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.

You have two fields with company id there, one for each table, and you only should return the one of products.

You're missing a field from products table.

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.