-- your code goes hereCREATE TABLE biblo(id INTEGER, emri TEXT, kategoria TEXT, cmimi INTEGER);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(1, 'Heron Cakiqi', 'aksion', 10);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(2, 'Leonardo Abazi', 'komedi', 15);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(3, 'Ylber Havolli', 'komedi', 20);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(4, 'Agon Ibrahimi', 'drame', 10);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(5, 'Fiton Prokorogja', 'sci-fi', 9);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(6, 'Festim Dedinca', 'romance', 5);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(7, 'Pleurat Gashi', 'aksion', 14);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(8, 'Meriton Husaj', 'kontabilitet', 19);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(9, 'Dardan Nishevci', 'sport', 7);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(10, 'Veton Siqani', 'drame', 9);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(11, 'Vigan Qerimi', 'sport', 20);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(12, 'Hana Gashi', 'aksion', 11);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(13, 'Bardha Celaj', 'komedi', 50);
INSERT INTO biblo(id, emri, kategoria, cmimi)
VALUES(14, 'Rozafa Celaj', 'aksion', 30);
 
 
UPDATE biblo
SET cmimi = 25
WHERE emri = 'Bardha Celaj';
 
ALTER TABLE biblo
ADD COLUMN ngjyra TEXT;
 
UPDATE biblo
SET ngjyra = 'e kuqe'
WHERE emri = 'Leonardo Abazi';
 
SELECT COUNT(*) FROM emri;

LS0geW91ciBjb2RlIGdvZXMgaGVyZUNSRUFURSBUQUJMRSBiaWJsbyhpZCBJTlRFR0VSLCBlbXJpIFRFWFQsIGthdGVnb3JpYSBURVhULCBjbWltaSBJTlRFR0VSKTsKSU5TRVJUIElOVE8gYmlibG8oaWQsIGVtcmksIGthdGVnb3JpYSwgY21pbWkpClZBTFVFUygxLCAnSGVyb24gQ2FraXFpJywgJ2Frc2lvbicsIDEwKTsKSU5TRVJUIElOVE8gYmlibG8oaWQsIGVtcmksIGthdGVnb3JpYSwgY21pbWkpClZBTFVFUygyLCAnTGVvbmFyZG8gQWJhemknLCAna29tZWRpJywgMTUpOwpJTlNFUlQgSU5UTyBiaWJsbyhpZCwgZW1yaSwga2F0ZWdvcmlhLCBjbWltaSkKVkFMVUVTKDMsICdZbGJlciBIYXZvbGxpJywgJ2tvbWVkaScsIDIwKTsKSU5TRVJUIElOVE8gYmlibG8oaWQsIGVtcmksIGthdGVnb3JpYSwgY21pbWkpClZBTFVFUyg0LCAnQWdvbiBJYnJhaGltaScsICdkcmFtZScsIDEwKTsKSU5TRVJUIElOVE8gYmlibG8oaWQsIGVtcmksIGthdGVnb3JpYSwgY21pbWkpClZBTFVFUyg1LCAnRml0b24gUHJva29yb2dqYScsICdzY2ktZmknLCA5KTsKSU5TRVJUIElOVE8gYmlibG8oaWQsIGVtcmksIGthdGVnb3JpYSwgY21pbWkpClZBTFVFUyg2LCAnRmVzdGltIERlZGluY2EnLCAncm9tYW5jZScsIDUpOwpJTlNFUlQgSU5UTyBiaWJsbyhpZCwgZW1yaSwga2F0ZWdvcmlhLCBjbWltaSkKVkFMVUVTKDcsICdQbGV1cmF0IEdhc2hpJywgJ2Frc2lvbicsIDE0KTsKSU5TRVJUIElOVE8gYmlibG8oaWQsIGVtcmksIGthdGVnb3JpYSwgY21pbWkpClZBTFVFUyg4LCAnTWVyaXRvbiBIdXNhaicsICdrb250YWJpbGl0ZXQnLCAxOSk7CklOU0VSVCBJTlRPIGJpYmxvKGlkLCBlbXJpLCBrYXRlZ29yaWEsIGNtaW1pKQpWQUxVRVMoOSwgJ0RhcmRhbiBOaXNoZXZjaScsICdzcG9ydCcsIDcpOwpJTlNFUlQgSU5UTyBiaWJsbyhpZCwgZW1yaSwga2F0ZWdvcmlhLCBjbWltaSkKVkFMVUVTKDEwLCAnVmV0b24gU2lxYW5pJywgJ2RyYW1lJywgOSk7CklOU0VSVCBJTlRPIGJpYmxvKGlkLCBlbXJpLCBrYXRlZ29yaWEsIGNtaW1pKQpWQUxVRVMoMTEsICdWaWdhbiBRZXJpbWknLCAnc3BvcnQnLCAyMCk7CklOU0VSVCBJTlRPIGJpYmxvKGlkLCBlbXJpLCBrYXRlZ29yaWEsIGNtaW1pKQpWQUxVRVMoMTIsICdIYW5hIEdhc2hpJywgJ2Frc2lvbicsIDExKTsKSU5TRVJUIElOVE8gYmlibG8oaWQsIGVtcmksIGthdGVnb3JpYSwgY21pbWkpClZBTFVFUygxMywgJ0JhcmRoYSBDZWxhaicsICdrb21lZGknLCA1MCk7CklOU0VSVCBJTlRPIGJpYmxvKGlkLCBlbXJpLCBrYXRlZ29yaWEsIGNtaW1pKQpWQUxVRVMoMTQsICdSb3phZmEgQ2VsYWonLCAnYWtzaW9uJywgMzApOwoKClVQREFURSBiaWJsbwpTRVQgY21pbWkgPSAyNQpXSEVSRSBlbXJpID0gJ0JhcmRoYSBDZWxhaic7CgpBTFRFUiBUQUJMRSBiaWJsbwpBREQgQ09MVU1OIG5nanlyYSBURVhUOwoKVVBEQVRFIGJpYmxvClNFVCBuZ2p5cmEgPSAnZSBrdXFlJwpXSEVSRSBlbXJpID0gJ0xlb25hcmRvIEFiYXppJzsKClNFTEVDVCBDT1VOVCgqKSBGUk9NIGVtcmk7