create subtable FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal+FComis as FSalTotal from FUNCIONARIO where DepNo=30;

create table FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal+FComis as FSalTotal from FUNCIONARIO where DepNo=30;

alter table FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal+FComis as FSalTotal from FUNCIONARIO where DepNo=30;

create table FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal+FComis from FUNCIONARIO where DepNo=30;

create table FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal*FComis as FSalTotal from FUNCIONARIO where DepNo=30;