CREATE VIEW sample.employee_view (ssn,fname,minit,lname,address,sex,salary,superssn,dno) AS
/* ALGORITHM=UNDEFINED */
select `sample`.`employee`.`ssn` AS `ssn`,`sample`.`employee`.`fname` AS `fname`,`sample`.`employee`.`minit` AS `minit`,`sample`.`employee`.`lname` AS `lname`,`sample`.`employee`.`address` AS `address`,`sample`.`employee`.`sex` AS `sex`,`sample`.`employee`.`salary` AS `salary`,`sample`.`employee`.`superssn` AS `superssn`,`sample`.`employee`.`dno` AS `dno` from `sample`.`employee`