现在需要frist name, email, attendeeID . ordered by first name.这段code应该如何modify
select a.attendeeid, attendeefirstname, attendeelastname, attendeeemail, c.companyname, c.companycountry, r.eventid, r.ordertypecode
from tblregistrationorders r inner join tblattendees a on r.attendeeid = a.attendeeid
inner join tblcompanies c on c.companyid = a.attendeecompanyid
where eventid like 'RSS%'
and (ordertypecode = 'Paid Attendee' or ordertypecode = 'Speaker' or ordertypecode = 'Sponsor Comp' or ordertypecode = 'Advisor')
and ordercanceldate is null
and (substitutedbyordernum is null or substitutedbyordernum = '0' or substitutedbyordernum = '')