Functionality for min(column) max(colum) and 'GROUP BY column'

[focussing]

Hi Maurits, how are you?

I am converting an application form accessing a mysql database directly to using a REST API.

One sql string is puzzling me a bit:

sql = string.Format("SELECT adres, kwhmeter_id, min(pulsen), max(pulsen) FROM 'pulsen' WHERE (gebruiker_id=@gebruiker_id) AND (timestamp>='{0}') AND (timestamp<='{1}') GROUP BY adres", StartDate.ToString(MYSQL_DATE_FORMAT), EndDate.ToString(MYSQL_DATE_FORMAT));

Could not find it in the docs, so I am wondering...
Is the following functionality present in your api.php?

• min(column)
• max(colum)
• GROUP BY column

If not do you have suggestions in how to implement it?

Thanks on forehand!

Looking forward to hearing from you,
Best regards,
Raymond