CREATE TABLE Students ( name varchar( 10 ) , direction varchar( 20 ) , course DOUBLE, practice varchar( 40 ) ) ;
SELECT * FROM Students;
INSERT INTO Students VALUES
( 'Marat' , 'IS' , 2 , 'web' ) ,
( 'Adam' , 'VT' , 2 , 'sysadmin' ) ,
( 'Sam' , 'IS' , 1 , 'backend' ) ,
( 'Marat' , 'IS' , 1 , 'frontend' ) ,
( 'Simon' , 'VT' , 2 , 'sysadmin' ) ,
( 'Marat' , 'VT' , 1 , 'frontend' ) ;
SELECT * FROM Students;
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' , 'frontend' ) ;
SELECT * FROM Prac;
Q1JFQVRFIFRBQkxFIFN0dWRlbnRzIChuYW1lIHZhcmNoYXIoMTApLCBkaXJlY3Rpb24gdmFyY2hhcigyMCksIGNvdXJzZSBET1VCTEUsIHByYWN0aWNlIHZhcmNoYXIoNDApKTsKU0VMRUNUICogRlJPTSBTdHVkZW50czsKSU5TRVJUIElOVE8gU3R1ZGVudHMgVkFMVUVTCignTWFyYXQnLCAnSVMnLCAyLCAnd2ViJyksCignQWRhbScsICdWVCcsIDIsICdzeXNhZG1pbicpLAooJ1NhbScsICdJUycsIDEsICAnYmFja2VuZCcpLAooJ01hcmF0JywgJ0lTJywgMSwgJ2Zyb250ZW5kJyksCignU2ltb24nLCAnVlQnLCAyLCAnc3lzYWRtaW4nKSwKKCdNYXJhdCcsICdWVCcsIDEsICdmcm9udGVuZCcpOwpTRUxFQ1QgKiBGUk9NIFN0dWRlbnRzOwoKCkNSRUFURSBUQUJMRSBQcmFjIChkaXJlY3Rpb24gdmFyY2hhcigxMCksIGNvdXJzZSBET1VCTEUsIHByYWN0aWNlIHZhcmNoYXIoMjApLCBjb21wYW55IHZhcmNoYXIoMzApKTsKU0VMRUNUICogRlJPTSBQcmFjOwpJTlNFUlQgSU5UTyBQcmFjIFZBTFVFUwooJ0lTJywgMiwgJ3dlYicsICdiYW5rJyksCignVlQnLCAyLCAnc3lzYWRtaW4nLCAndGVjaCBjb21wYW55JyksCignSVMnLCAxLCAnYmFja2VuZCcsICd0ZWNoIGNvbXBhbnknKSwKKCdJUycsIDEsICdmcm9udGVuZCcsICd0ZWNoIGNvbXBhbnknKSwKKCdWVCcsIDMsICdzeXNhZG1pbicsICdiYW5rJyksCignVlQnLCAxLCAnYmFrJywgJ2Zyb250ZW5kJyk7ClNFTEVDVCAqIEZST00gUHJhYzsK