4_4!.sql

to study the example of creation of tables, formative DB, and filling with their information. Using

--Students KS


select st_surname as LName, left(st_name,1) as FName, left(st_pname,1) as Mname, kurs as Kurs 
	from Person t1 
INNER JOIN Student t2  
ON t1.id_person=t2.id_person 
INNER JOIN Grouppa t3  
ON t2.id_group=t3.id_group 
where left(group_name,2)='KS'