1. List employee number, name, date of birth, gender = "female", marital status =. f .

2.name = "Hu "list

3. list of 3.recno () >; =2

4. Copy all salaries with salary * 1. 1

5. Fill in the date of birth for Name = "Wang Aimin" with {1950- 10-06}.

Step 6 delete the date of birth

7. All recalls

8. Select avg (salary) from zg with gender = "male"

Select avg (salary) from zg, where gender = "female ".

9. Go to the bottom

? Record number ()

10. select title, sum (salary) from zg group by title.