/* Write your PL/SQL query statement below */


-- create a table
CREATE TABLE Cinema (
    id INT,
    movie VARCHAR, 
    description VARCHAR,
    rating FLOAT,
    CONSTRAINT PK_id PRIMARY KEY (id)
);
-- insert some values
INSERT INTO Cinema (id, movie, description, rating) VALUES (1, 'War', "great 3D", 8.9);
INSERT INTO Cinema (id, movie, description, rating) VALUES (2, 'Science', "fiction", 8.5);
INSERT INTO Cinema (id, movie, description, rating) VALUES (3, 'Irish', "boring", 6.2);
INSERT INTO Cinema (id, movie, description, rating) VALUES (4, 'Ice Song', "Fantacy", 8.6);
INSERT INTO Cinema (id, movie, description, rating) VALUES (5, 'House Card', "Interesting", 9.1);


-- SELECT * FROM Cinema WHERE id%2 <> 0 AND description <> "boring" ORDER BY rating DESC;

/*
SELECT 
id AS "id",
movie AS "movie",
description AS "description",
rating AS "rating"
FROM cinema 
WHERE MOD(id, 2) = 1 AND description != 'boring' 
ORDER BY rating DESC;
*/
SELECT * 
FROM Cinema 
WHERE MOD(id,2) <> 0 
AND description <> 'boring'
ORDER BY rating DESC;