Write solution to find odd-even number from column in SQL

00:00 Write solution to find odd number
02:37 Write solution to list of Odd and Even number in list using CASE statement
04:39 Write solution to list of odd and Even Number in separate column

create table numbertbl (id int);

insert into numbertbl values (1);
insert into numbertbl values (2);
insert into numbertbl values (3);
insert into numbertbl values (4);
insert into numbertbl values (5);
insert into numbertbl values (6);
insert into numbertbl values (7);
insert into numbertbl values (8);
insert into numbertbl values (9);
insert into numbertbl values (10);
insert into numbertbl values (11);

select * from numbertbl

--Write solution to find odd number
select id as "OddNumberList"
from numbertbl
where id%2!=0
--Write solution to list of Odd and Even number in list.
select id,
case when id%2=0 then 'EvenNumber'
else 'OddNumber'
End as TypeOfNumber
from numbertbl

--Write solution to list of odd and Even Number in separate column
with cte as
(
select id,
ROW_NUMBER() over (partition by id%2=0 order by id) as rn,
case when id%2=0 then 'EvenNumber'
else 'OddNumber'
End as TypeOfNumber
from numbertbl
)

--select * from cte

select
max(case when TypeOfNumber='EvenNumber' then id End) as List_Of_EvenNumber,
max(case when TypeOfNumber='OddNumber' then id End) as List_Of_OddNumber
from cte
group by rn
order by rn