In the query activity, select the resource as actual rt event for which you want to exract data for. Do not select the 'rtevent' as resource.
Select the one you created in Adobe campaign> marketing plans> transactional messages> Event configuration.
Once you select that, you can use any filter like email is not empty and got to additional data tab and add elememts Delivery logs and Tracking logs. You can add them as collection or aggregates as neded.
It depends on what fields you are pulling from the table and also see if there are those number of delivery logs or tracking logs exist for every event (the number of collections you configure it on the additional data section). If you have the data but is not seen in the UI, try exporting them in file and see. If that does not show up, I would suggest you to create support ticket. Thanks!