A column contains grades from $0$ to $10,$ but a WHERE clause specifies values from $0$ to $100.$ A $$ index can be used to modify the column values and process the queries.

multi$-$level

logical

single$-$level

function