SQLize | PHPize | SQLtest

CREATE TABLE Books ([ISBN] int, [Title] varchar(40), [Author] varchar(40), [Publication_Year] date, [Price] int); INSERT INTO Books 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 Hundread Years of Solitude', 'Gabriel Garcia Marquez', '2013-02-23', null), (1005, 'A Passsage to India', 'E.M. Foster', '2009-05-09', 1750.00); SELECT * FROM Books; SELECT * FROM Books WHERE Publication_Year IS NULL OR Price IS NULL; SELECT * FROM Books WHERE Price IS NOT NULL; SELECT TOP 3 * FROM Books; UPDATE Books SET Author = 'Tom Cruise' WHERE ISBN = 1003; SELECT * FROM Books; You sent ttake palang pota