How to create XML from SQL select query?

I was building integration and was required to create an XML file as end result. I found out that you are able to generate XML formatted results based on SQL query just a simple addition to the query itself:

I’m using this kind of statement in Power Automate’s execute SQL Query -action and then just saving the outcome as an XML file in SharePoint. 

I found the article below useful, and there’s nicely explained all the other stuff that you can do with SQL and XML. 

https://www.sqlshack.com/generate-xml-forms-or-xml-data-type-documents-in-sql-server/

Thanks!