a) create table  employe          (employe-id int , employe-name varchar(10), employe-sex varchar(5),           employe-age int , employe-branch  varchar(20),   employe-wage  numeric(8,2) ) b) select sum( employe-wage )     from   employe    group by  employe-branch c)select  employe-name,avg( employe-wage )   from  employe    group by  employe-branch  having   employe-wage > avg( employe-wage )