4_3.sql

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

select st_surname, left(st_name,1) as st_name, left(st_pname,1) as st_pname 
	from Person
where   
	st_military=1 and (YEAR(getdate())-YEAR(st_birthday))>=18 and (YEAR(getdate())-YEAR(st_birthday))<25