【单选题】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 Berkeley but who do not live on 123 Mai...
A.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City= 'Berkeley' and Street_Address!= '123 Main St.' order by Surname desc;
B.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City= 'Berkeley' and Street_Address!= '123 Main St.' order by Surname;
C.
select * from tblMember where City= Berkeley and Street_Address!= '123 Main St.' order by Surname;
D.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City= Berkeley and Street_Address!= '123 Main St.' order by Surname;