Create table cinema
(
Id int primary key identity(1,1) not null,
movie varchar(255) not null,
[description] varchar(255) not null,
rating int not null,
)

insert into cinema(movie,[description],rating) values('War',' great 3D', 8.9),('Science','fiction',8.5),('irish','boring',6.2),('Ice song','Fantacy',8.6),(' House card','Interesting',9.1)

select distinct(l.Id),l.movie,l.[description],l.rating from cinema l,cinema l1  where l.description!='boring'  and l.Id%2=1 order by rating desc