How to write Rails scope for this SQL query

I have an issue to get rows from database by multiple conditions.
I have a table Slot and SlotAlteration.