【单选题】In the relation of tblHire (Loan_Num, ember_Id,Video_Code,Hire_Period, Issue_Date,Due_Date,Return_Date, Reminded,Fine,Paid), Which SQL statements can find the average fine(s) by member where the avera...
A.
select Member_Id , AVG ( Fine ) as Average_Fine from tblHire group by Member_Id where AVG ( Fine )> 16 ;
B.
select Member_Id , AVG ( Fine ) as Average_Fine from tblHire group by Member_Id having AVG ( Fine )> 16 ;
C.
select Member_Id , average ( Fine ) as Average_Fine from tblHire group by Member_Id having average ( Fine )> 16 ;
D.
select Member_Id , AVG ( Fine ) as Average_Fine from tblHire order by Member_Id having AVG ( Fine )> 16 ;