What's the query if i wanna make a new field in sql

Question

If the the values are odd and even, if 1%2 = 0 then even, if 1%2 = 1 then odd

Answer 1

For adding a new column, try:

https://www.w3schools.com/sql/sql_alter.asp

I'm not sure about the intended relevance of the rest of the original post.