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==