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"