how to query orders which have hold in them in order management fusion using sql ?

Summary:

how to query orders which have hold in them in order management fusion using sql reports and analytics? Can anyone provide a sample sql
need to pull out a report of all orders which are in hold, with hold name and hold details and hold creation date and hold created by?

Content (please ensure you mask any confidential information):

how to query orders which have hold in them in order management fusion using sql reports and analytics? Can anyone provide a sample sqlneed to pull out a report of all orders which are in hold, with hold name and hold details and hold creation date and hold created by?