• I also noted the lack of a GROUP BY clause. After “assuming” that it was intended, my first thought was 8 (4 for the table, 4 for the index). Since that wasn’t offered, and the error wasn’t related to the lack of a GROUP BY, I came to 4.

    Beer's Law: Absolutum obsoletum
    "if it works it's out-of-date"