create table Library (div TEXT,floor int, num INT, responsible TEXT);
insert into Library values 
("fiction",2, 10000, "Adam"),
("non-fiction",2, 5000, "Zaqsy"),
("tech",1, 30000, "Gulzhamal"),
("history",3, 5000, "Zaman");
--
CREATE TABLE Books (name TEXT, year INT, author TEXT, div TEXT);
insert into Books values 
("algo", 2020, "Adam", 'tech'),
("c++", 1997, "Ritchie", 'tech'),
("python", 2005, "S", 'tech'),
("Harry Potter",1993,"Rouling","fiction"),
("The Dawns Here Are Quiet",1969,"Vasiliev","non-fiction"),
('Java',2008,"Kuke","tech"),
("SQL",2007,"Loiely","tech"),
("War and peace",1807,"Tolstoy","non-fiction"),
("The Decline and Destruction of Britain",1887,"Bradly","history"),
("A Hero of Our Time",1837,"Lermontov","fiction");
---SELECT *FROM Books;
---SELECT div, MAX(year) FROM Books GROUP BY div;
 
---SELECT * FROM Library JOIN Books ON Library.div=Books.div
 
---SELECT div FROM Library WHERE num > 5000;
 
---SELECT DISTINCT Library.floor FROM Library 
---INNER JOIN Books ON Library.div=Books.div 
---WHERE Books.year BETWEEN 1900 AND 2000;
 
---SELECT name,div FROM Books WHERE name LIKE '%B%';
 
SELECT Library.num FROM Library
INNER JOIN Books ON Library.div=Books.div
WHERE Books.year = 2008

Y3JlYXRlIHRhYmxlIExpYnJhcnkgKGRpdiBURVhULGZsb29yIGludCwgbnVtIElOVCwgcmVzcG9uc2libGUgVEVYVCk7Cmluc2VydCBpbnRvIExpYnJhcnkgdmFsdWVzIAooImZpY3Rpb24iLDIsIDEwMDAwLCAiQWRhbSIpLAooIm5vbi1maWN0aW9uIiwyLCA1MDAwLCAiWmFxc3kiKSwKKCJ0ZWNoIiwxLCAzMDAwMCwgIkd1bHpoYW1hbCIpLAooImhpc3RvcnkiLDMsIDUwMDAsICJaYW1hbiIpOwotLQpDUkVBVEUgVEFCTEUgQm9va3MgKG5hbWUgVEVYVCwgeWVhciBJTlQsIGF1dGhvciBURVhULCBkaXYgVEVYVCk7Cmluc2VydCBpbnRvIEJvb2tzIHZhbHVlcyAKKCJhbGdvIiwgMjAyMCwgIkFkYW0iLCAndGVjaCcpLAooImMrKyIsIDE5OTcsICJSaXRjaGllIiwgJ3RlY2gnKSwKKCJweXRob24iLCAyMDA1LCAiUyIsICd0ZWNoJyksCigiSGFycnkgUG90dGVyIiwxOTkzLCJSb3VsaW5nIiwiZmljdGlvbiIpLAooIlRoZSBEYXducyBIZXJlIEFyZSBRdWlldCIsMTk2OSwiVmFzaWxpZXYiLCJub24tZmljdGlvbiIpLAooJ0phdmEnLDIwMDgsIkt1a2UiLCJ0ZWNoIiksCigiU1FMIiwyMDA3LCJMb2llbHkiLCJ0ZWNoIiksCigiV2FyIGFuZCBwZWFjZSIsMTgwNywiVG9sc3RveSIsIm5vbi1maWN0aW9uIiksCigiVGhlIERlY2xpbmUgYW5kIERlc3RydWN0aW9uIG9mIEJyaXRhaW4iLDE4ODcsIkJyYWRseSIsImhpc3RvcnkiKSwKKCJBIEhlcm8gb2YgT3VyIFRpbWUiLDE4MzcsIkxlcm1vbnRvdiIsImZpY3Rpb24iKTsKLS0tU0VMRUNUICpGUk9NIEJvb2tzOwotLS1TRUxFQ1QgZGl2LCBNQVgoeWVhcikgRlJPTSBCb29rcyBHUk9VUCBCWSBkaXY7CgotLS1TRUxFQ1QgKiBGUk9NIExpYnJhcnkgSk9JTiBCb29rcyBPTiBMaWJyYXJ5LmRpdj1Cb29rcy5kaXYKCi0tLVNFTEVDVCBkaXYgRlJPTSBMaWJyYXJ5IFdIRVJFIG51bSA+IDUwMDA7CgotLS1TRUxFQ1QgRElTVElOQ1QgTGlicmFyeS5mbG9vciBGUk9NIExpYnJhcnkgCi0tLUlOTkVSIEpPSU4gQm9va3MgT04gTGlicmFyeS5kaXY9Qm9va3MuZGl2IAotLS1XSEVSRSBCb29rcy55ZWFyIEJFVFdFRU4gMTkwMCBBTkQgMjAwMDsKCi0tLVNFTEVDVCBuYW1lLGRpdiBGUk9NIEJvb2tzIFdIRVJFIG5hbWUgTElLRSAnJUIlJzsKClNFTEVDVCBMaWJyYXJ5Lm51bSBGUk9NIExpYnJhcnkKSU5ORVIgSk9JTiBCb29rcyBPTiBMaWJyYXJ5LmRpdj1Cb29rcy5kaXYKV0hFUkUgQm9va3MueWVhciA9IDIwMDg=