There is hereby levied an excise tax of 4% upon the gross proceeds or gross receipts derived from all rent for every occupancy of a room or rooms in a hotel in the city, except that this tax shall not be imposed where the rent is less than $5 per day.