![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
In the relation of tblMember (Member_Id, Title, Surname, Fname, Street_Address, Suburb, City, Phone, Email) ,Which SQL Command can find the members who live in Oakland, show Member Id, Surname, First Name, Street Address and City and sort by surname?
A.
select * from tblMember where City= 'Oakland' order by Surname;
B.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City=” Oakland ” order by Surname desc;
C.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City= 'Oakland' order by S urname;
D.
select * from tblMember where City = 'Oakland' order by Surname asc ;