It depends on where you are. As a kid in the 70s and 80s in Rhode Island, every school in my town had an RN. If they were absent, there wasn’t a substitute.
Where I now live in NJ, every school building has an RN. In addition to sick kids, the nurse handles health-related paperwork (documenting food allergiest, etc)…