Getting a count of correct and incorrect test attempts
You don't need the second Date in your select or grouping.  Other than that, the query itself looks fine.

I'm a bit more worried about how your table is built, though.


There appear to be duplicate records.  How would you go about selecting a specific record?
Correct and Incorrect are functionally dependent: if one has 0, the other must have 1.


If you have control over the structure of this table, you may want to look into normalising it.