I am trying to get customers from the database whose order was cancelled, and I am able to do this via Query. But I think the standard way should be without using Queries. So is there a way I can accomplish this? I searched on google but result is quite ambiguous and mostly for Magento 1.x where as I need for Magento 2.3.
My Query:
SELECT customer_id, count(`entity_id`) as custCount from $tableName WHERE `status` = 'cancel'
Any help here?