CREATE TABLE Prac (direction varchar(10), course DOUBLE, practice varchar(20), company varchar(30));
SELECT * FROM Prac;
INSERT INTO Prac VALUES
('IS', 2, 'web', 'bank'),
('VT', 2, 'sysadmin', 'tech company'),
('IS', 1, 'backend', 'tech company'),
('IS', 1, 'frontend', 'tech company'),
('VT', 3, 'sysadmin', 'bank'),
('VT', 1, 'bak', 'halyk bank');
--SELECT * FROM Prac
--WHERE company = 'tech company' AND direction = 'VT';
--SELECT company, direction FROM Prac
--WHERE direction ='IS';
SELECT company FROM Prac;
Q1JFQVRFIFRBQkxFIFByYWMgKGRpcmVjdGlvbiB2YXJjaGFyKDEwKSwgY291cnNlIERPVUJMRSwgcHJhY3RpY2UgdmFyY2hhcigyMCksIGNvbXBhbnkgdmFyY2hhcigzMCkpOwpTRUxFQ1QgKiBGUk9NIFByYWM7CklOU0VSVCBJTlRPIFByYWMgVkFMVUVTCignSVMnLCAyLCAnd2ViJywgJ2JhbmsnKSwKKCdWVCcsIDIsICdzeXNhZG1pbicsICd0ZWNoIGNvbXBhbnknKSwKKCdJUycsIDEsICdiYWNrZW5kJywgJ3RlY2ggY29tcGFueScpLAooJ0lTJywgMSwgJ2Zyb250ZW5kJywgJ3RlY2ggY29tcGFueScpLAooJ1ZUJywgMywgJ3N5c2FkbWluJywgJ2JhbmsnKSwKKCdWVCcsIDEsICdiYWsnLCAnaGFseWsgYmFuaycpOwotLVNFTEVDVCAqIEZST00gUHJhYwotLVdIRVJFIGNvbXBhbnkgPSAndGVjaCBjb21wYW55JyBBTkQgZGlyZWN0aW9uID0gJ1ZUJzsKCi0tU0VMRUNUIGNvbXBhbnksIGRpcmVjdGlvbiBGUk9NIFByYWMKLS1XSEVSRSBkaXJlY3Rpb24gPSdJUyc7CgpTRUxFQ1QgY29tcGFueSBGUk9NIFByYWM7CgoK