Is this query selecting items with a rating of 4?

No, it only selects items with a rating of either 3 or 5Yes, since it selects items rated between 3 and 5

No, it only selects items with a rating of either 3 or 5.