-- Create a table

CREATE TABLE candy (
name TEXT NOT NULL,
weight INTEGER,
price INTEGER
);

-- Insert some values

INSERT INTO candy VALUES ("Roshen Crazy Bees", 7, 10);
INSERT INTO candy VALUES ("Roshen Lady Bug", 10, 10);
INSERT INTO candy VALUES ("Roshen Yogurtini Stawberry", 5, 9);
INSERT INTO candy VALUES ("Roshen Yogurtini Peach", 5, 10);
INSERT INTO candy VALUES ("Roshen Yogurtini Cheery", 5, 11);

-- Fetch some values

SELECT * FROM candy WHERE price = 10;