query to display all unencrypted messages from one user

user_messages.sql

select event_json.json::json->'content'->>'body' as message,
       events.room_id,
       room_stats_state.name,
       events.sender
from events 
left outer join event_json on 
    events.event_id=event_json.event_id
left outer join room_stats_state on 
    room_stats_state.room_id=events.room_id
where event_json.json::json->'content'->>'body'<>'' and events.sender='@ACCOUNT_NAME:SERVER.DOM';