[SQL] insert only if conditions are met?

[Henry Ortega]

Is there a way to insert a record only if a certain
condition is met?

Something like:
insert into employee values('lastname','firstname',8) where
(condition here.. select sum(ofsomething) from xx where sum(ofsomething)>0 )

Is this possible at all with just plain SQL?