Qus: Can anyone help with a query for bounced emails in Marketing Cloud?
Select Status from _Subscriber where Status = 'bounced'
This query can be run in parent BU on query studio or via automation. Also you can fetch all the columns you want. Search for subscribers data view online for more information.