CREATE TABLE Students (id SERIAL PRIMARY KEY, name CHAR(20), age INT, gpa DOUBLE);
---создать таблицу
 
 
INSERT INTO Students VALUES 
(1, 'Adam', 19, 4.0),
(2, 'Zaqsy', 18, 5.0),
(3, 'aaa', 20, 2.5),
(4, 'Zaqsy', 21, 2.0);
---заполнить таблицу
 
---SELECT * FROM Students;
---выборка из таблицы
 
UPDATE Students SET gpa = 3.5 WHERE id = 2;
---изменить данные в таблице
 
 
---SELECT * FROM Students;
 
---SELECT * FROM Students WHERE gpa >= 2.3;
---все студенты с gpa больше или равно 2.3
 
SELECT name FROM Students WHERE name LIKE "_a%";
 
 

Q1JFQVRFIFRBQkxFIFN0dWRlbnRzIChpZCBTRVJJQUwgUFJJTUFSWSBLRVksIG5hbWUgQ0hBUigyMCksIGFnZSBJTlQsIGdwYSBET1VCTEUpOwotLS3RgdC+0LfQtNCw0YLRjCDRgtCw0LHQu9C40YbRgwoKCklOU0VSVCBJTlRPIFN0dWRlbnRzIFZBTFVFUyAKKDEsICdBZGFtJywgMTksIDQuMCksCigyLCAnWmFxc3knLCAxOCwgNS4wKSwKKDMsICdhYWEnLCAyMCwgMi41KSwKKDQsICdaYXFzeScsIDIxLCAyLjApOwotLS3Qt9Cw0L/QvtC70L3QuNGC0Ywg0YLQsNCx0LvQuNGG0YMKCi0tLVNFTEVDVCAqIEZST00gU3R1ZGVudHM7Ci0tLdCy0YvQsdC+0YDQutCwINC40Lcg0YLQsNCx0LvQuNGG0YsKClVQREFURSBTdHVkZW50cyBTRVQgZ3BhID0gMy41IFdIRVJFIGlkID0gMjsKLS0t0LjQt9C80LXQvdC40YLRjCDQtNCw0L3QvdGL0LUg0LIg0YLQsNCx0LvQuNGG0LUKCgotLS1TRUxFQ1QgKiBGUk9NIFN0dWRlbnRzOwoKLS0tU0VMRUNUICogRlJPTSBTdHVkZW50cyBXSEVSRSBncGEgPj0gMi4zOwotLS3QstGB0LUg0YHRgtGD0LTQtdC90YLRiyDRgSBncGEg0LHQvtC70YzRiNC1INC40LvQuCDRgNCw0LLQvdC+IDIuMwoKU0VMRUNUIG5hbWUgRlJPTSBTdHVkZW50cyBXSEVSRSBuYW1lIExJS0UgIl9hJSI7Cgo=