use workplace1
select firstName
from dbo.person
where personID=274;

select department_name
from dbo.department
where department_code='01';

select count(*)
from dbo.person
where personID < 276;

select fullname as name -- name is heading
from dbo.person
where personID=274
union
select fullname as nam
from dbo.person
where personID=275
