Using subquery in a Check statement in Oracle

So I was trying to work this out but it seems that the last line (the check) doesn't allow sub queries in it. Any way to make this work Oracle? CREATE TABLE Tank ( n_id int, day...