写几句access查询语句,19时截止

1.select pno from pro,off where off.dno=pro.dno

2,select count(pno) from emp where eno='李%'

3.select ono from off,emp,pro where off.dno=pro.dno and pro.pno=emp.pno and emp.eno='方正'

4.

create view is_zhigong

as

selcet emp.eno,pro.dno,pro.pno,off.ono from emp,pro,off where off.dno=pro.dno and pro.pno=emp.pno

5. select count(tel) from tel,off where tel.ono=off.ono and off.dno='振兴学院'

6.select avg(sa) from semp

---