CODE EXAMPLE FOR SQL

sql mod even odd

#to check eif id is even
select city from station where mod(id,2) = 0;
#to check eif id is odd
select city from station where mod(id,2) <> 0;