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);
SELECT * FROM Students;
UPDATE Students SET gpa = 3.5 WHERE name = 'Zaqsy';
SELECT * FROM Students;
INSERT INTO Students (name, direction, course, education_level, practice)
VALUES ('Marat', 'IS', 2, 'bak', 'web'),
('Adam', 'VT', 2, 'bak', 'sysadmin'),
('Sam', 'IS', 1, 'mag', 'backend'),
('Marat', 'IS', 1, 'bak', 'frontend'),
('Simon', 'VT', 2, 'mag', 'sysadmin'),
('Marat', 'VT', 1, 'bak', 'frontend');
Q1JFQVRFIFRBQkxFIFN0dWRlbnRzIChpZCBTRVJJQUwgUFJJTUFSWSBLRVksIG5hbWUgQ0hBUigyMCksIGFnZSBJTlQsIGdwYSBET1VCTEUpOwoKSU5TRVJUIElOVE8gU3R1ZGVudHMgVkFMVUVTIAooMSwgJ0FkYW0nLCAxOSwgNC4wKSwKKDIsICdaYXFzeScsIDE4LCA1LjApOwpTRUxFQ1QgKiBGUk9NIFN0dWRlbnRzOwoKVVBEQVRFIFN0dWRlbnRzIFNFVCBncGEgPSAzLjUgV0hFUkUgbmFtZSA9ICdaYXFzeSc7ClNFTEVDVCAqIEZST00gU3R1ZGVudHM7CgpJTlNFUlQgSU5UTyBTdHVkZW50cyAobmFtZSwgZGlyZWN0aW9uLCBjb3Vyc2UsIGVkdWNhdGlvbl9sZXZlbCwgcHJhY3RpY2UpClZBTFVFUyAoJ01hcmF0JywgJ0lTJywgMiwgJ2JhaycsICd3ZWInKSwKICAgICAgICgnQWRhbScsICdWVCcsIDIsICdiYWsnLCAnc3lzYWRtaW4nKSwKICAgICAgICgnU2FtJywgJ0lTJywgMSwgJ21hZycsICdiYWNrZW5kJyksCiAgICAgICAoJ01hcmF0JywgJ0lTJywgMSwgJ2JhaycsICdmcm9udGVuZCcpLAogICAgICAgKCdTaW1vbicsICdWVCcsIDIsICdtYWcnLCAnc3lzYWRtaW4nKSwKICAgICAgICgnTWFyYXQnLCAnVlQnLCAxLCAnYmFrJywgJ2Zyb250ZW5kJyk7CiA=