求大佬帮助写下下面九道题

没人嘛 各位大哥救急呀

---------------1------------------
select * from ORADH where budate BETWEEN 20201001 and 20201031
---------------2-----------------
select * from ORDERD where billid in (
select billid from ORADH where allmany>10000)
---------------3-----------------
select wendor,max(allmany) allmany_max from ORADH
GROUP BY wendor
---------------4-----------------
select top 10 Opertor,sum(allmany) allmany_sum from ORADH
GROUP BY Opertor order by allmany_sum desc
---------------5-----------------
select a.wendor,max(b.pric) pric_max from ORADH a,ORDERD b
where a.billid=b.billid
GROUP BY a.wendor

---------------6-----------------
select a.wendor,max(b.pric) pric_max,sum(a.allmany) allmany_sum from ORADH a,ORDERD b
where a.billid=b.billid
GROUP BY a.wendor
---------------7------------------
select wendor,count(1) ascount from ORADH
GROUP BY wendor
---------------8------------------
select * from ORADH where NO in (
select NO from Stockd)
---------------9----------------
select * from ORADH a full join
Stockd b on a.NO=b.NO
where a.NO is null or b.NO is null
or a.allmany<>b.allmoney

你发出来的时候我都下班了

（学生代做价格优惠），QQ1515749394需要联系我，可走咸鱼平台交易