4_3.sql

来自「to study the example of creation of tabl」· SQL 代码 · 共 6 行

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