/*CATAPANG ALLEN ANGELO*/
CREATE TABLE tblBooks
([ISBN] int, [TITLE] varchar(40), [AUTHOR] varchar(40), [PUBLICATIONYEAR] date, [PRICE] decimal(10,2))
INSERT INTO tblBooks
([ISBN], [TITLE], [AUTHOR], [PUBLICATIONYEAR], [PRICE])
VALUES
(1001, 'Anna Karenina', 'Leo Tolstoy', '2008-03-25', 3500.00),
(1002, 'To Kill a mockingbird', 'Harper Lee', '2010-07-30', 2750.00),
(1003, 'The great gatsby', 'F.Scott Fitzgerald', NULL, 2000.00),
(1004, 'One Hundred Years of Solitude', 'Gabriel Garcia Marquez', '2013-02-23', NULL),
(1005, 'A Passage to India', 'E.M.Foster', '2009-05-09', 1750.00)
SELECT * FROM tblBooks
SELECT * FROM tblBooks WHERE PUBLICATIONYEAR = '2005' OR PRICE IS NULL
SELECT TITLE, PRICE FROM tblBooks
Telegram: DB developers channel