How can I change SQL Query to Odata Query

[Sam00900]

Hi, How can I convert This SQL Query to Odata Query

SELECT FirstName, LastName, MobileNo, COUNT(1) as CNT FROM CUSTOMER GROUP BY FirstName, LastName, MobileNo;

[monty241]

A possible way is to use the online sql editor. It is closed source but when you execute this query using sql on an OData source such as exact online you can find the OData calls in select * from sessionios