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;
-- Выведите имена всех студентов 2 го курса ВТ, которые проходят практику в IT компании ( tech company)
SELECT name
FROM Students
WHERE direction = 'VT' AND course = 2 AND location = 'tech company' ;
-- Выведите все доступные для прохождения практики компании и виды практики для направления ИС
SELECT DISTINCT location, practice_type
FROM Prac
WHERE direction = 'IS' ;
-- Выведите количество компаний, в которых могут пройти практику студенты любых направлений
SELECT COUNT( DISTINCT location) AS company_count
FROM Prac;
Q1JFQVRFIFRBQkxFIFN0dWRlbnRzIChuYW1lIHZhcmNoYXIoMTApLCBkaXJlY3Rpb24gdmFyY2hhcigyMCksIGNvdXJzZSBET1VCTEUsIHByYWN0aWNlIHZhcmNoYXIoNDApKTsKU0VMRUNUICogRlJPTSBTdHVkZW50czsKCklOU0VSVCBJTlRPIFN0dWRlbnRzIFZBTFVFUwooJ01hcmF0JywgJ0lTJywgMiwgJ3dlYicpLAooJ0FkYW0nLCAnVlQnLCAyLCAnc3lzYWRtaW4nKSwKKCdTYW0nLCAnSVMnLCAxLCAgJ2JhY2tlbmQnKSwKKCdNYXJhdCcsICdJUycsIDEsICdmcm9udGVuZCcpLAooJ1NpbW9uJywgJ1ZUJywgMiwgJ3N5c2FkbWluJyksCignTWFyYXQnLCAnVlQnLCAxLCAnZnJvbnRlbmQnKTsKU0VMRUNUICogRlJPTSBTdHVkZW50czsKCkNSRUFURSBUQUJMRSBQcmFjIChkaXJlY3Rpb24gdmFyY2hhcigxMCksIGNvdXJzZSBET1VCTEUsIHByYWN0aWNlIHZhcmNoYXIoMjApLCBjb21wYW55IHZhcmNoYXIoMzApKTsKU0VMRUNUICogRlJPTSBQcmFjOwoKSU5TRVJUIElOVE8gUHJhYyBWQUxVRVMKKCdJUycsIDIsICd3ZWInLCAnYmFuaycpLAooJ1ZUJywgMiwgJ3N5c2FkbWluJywgJ3RlY2ggY29tcGFueScpLAooJ0lTJywgMSwgJ2JhY2tlbmQnLCAndGVjaCBjb21wYW55JyksCignSVMnLCAxLCAnZnJvbnRlbmQnLCAndGVjaCBjb21wYW55JyksCignVlQnLCAzLCAnc3lzYWRtaW4nLCAnYmFuaycpLAooJ1ZUJywgMSwgJ2JhaycsICdmcm9udGVuZCcpOwpTRUxFQ1QgKiBGUk9NIFByYWM7CgotLSDQktGL0LLQtdC00LjRgtC1INC40LzQtdC90LAg0LLRgdC10YUg0YHRgtGD0LTQtdC90YLQvtCyIDLQs9C+INC60YPRgNGB0LAg0JLQoiwg0LrQvtGC0L7RgNGL0LUg0L/RgNC+0YXQvtC00Y/RgiDQv9GA0LDQutGC0LjQutGDINCyIElUINC60L7QvNC/0LDQvdC40LggKHRlY2ggY29tcGFueSkKU0VMRUNUIG5hbWUKRlJPTSBTdHVkZW50cwpXSEVSRSBkaXJlY3Rpb24gPSAnVlQnIEFORCBjb3Vyc2UgPSAyIEFORCBsb2NhdGlvbiA9ICd0ZWNoIGNvbXBhbnknOwoKLS0g0JLRi9Cy0LXQtNC40YLQtSDQstGB0LUg0LTQvtGB0YLRg9C/0L3Ri9C1INC00LvRjyDQv9GA0L7RhdC+0LbQtNC10L3QuNGPINC/0YDQsNC60YLQuNC60Lgg0LrQvtC80L/QsNC90LjQuCDQuCDQstC40LTRiyDQv9GA0LDQutGC0LjQutC4INC00LvRjyDQvdCw0L/RgNCw0LLQu9C10L3QuNGPINCY0KEKU0VMRUNUIERJU1RJTkNUIGxvY2F0aW9uLCBwcmFjdGljZV90eXBlCkZST00gUHJhYwpXSEVSRSBkaXJlY3Rpb24gPSAnSVMnOwoKLS0g0JLRi9Cy0LXQtNC40YLQtSDQutC+0LvQuNGH0LXRgdGC0LLQviDQutC+0LzQv9Cw0L3QuNC5LCDQsiDQutC+0YLQvtGA0YvRhSDQvNC+0LPRg9GCINC/0YDQvtC50YLQuCDQv9GA0LDQutGC0LjQutGDINGB0YLRg9C00LXQvdGC0Ysg0LvRjtCx0YvRhSDQvdCw0L/RgNCw0LLQu9C10L3QuNC5ClNFTEVDVCBDT1VOVChESVNUSU5DVCBsb2NhdGlvbikgQVMgY29tcGFueV9jb3VudApGUk9NIFByYWM7Cg==