every drived table must have it's own alias

Question

i have the below MySQL query and when excecated it throwing an error "every drived table must have it's own alias"

select mfssessionId,
       senderMobile,
       receiverMobile,
       serviceName,
       channelName,
       createdAt LoginDate,
       status,
       substring(str, ps - 1, POSITION(',' in right(str, length(str) - ps + 1))) IpAddrs
from (select *,
             requestPayLoad                                                              str,
             POSITION('clientAddress' IN requestPayLoad)                                 ps,
             substring(str, usn - 1, POSITION(',' in right(str, length(str) - usn + 1))) Username
      from (select *, requestPayLoad str, POSITION('username' IN requestPayLoad) usn
            from loggingprofile13
            where mfsSessionId = 'WEB;32227221013;ZbJ7e')
     ) z;