I have one table filled with customer data. Some examples:
- date of last contact
Now I want to create a new table where only male customers are shown, ordered by the date of the last contact.
Is there a build in function to achieve data aggregation in this way or do I have to write a script? It occurs to me that there has to be some built-in way because I think it's a common task to evaluate data in this way.