Overlapped conditional groups

To group the employees by their length of service: less […]

Grouping rows by the specified order

List the number of female employees and their average a […]

Sorting by specified order

Compute the increase in sales of the first month of a q […]

Getting consecutive intervals by comparing to the previous day

Find out the longest run of consecutive days of gains i […]

Calculating YOY growth rates on selected records

Find out the three trading days with the highest stock […]

Filtering accumulated values

Find out the customers who account for half of the tota […]

Selecting subset according to the position

Divide the students into two classes according to their […]


Find out the employee whose age is the median of the ag […]

Find records with the maximum and the minimum

Find out the interval (days) between the joining date o […]

Combining tables with different structures

Find out the average age of female employees (including […]