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 Main St, show Member Id, Surname, First Name, Street Address and City and sort by surname?
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;