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 […]

Median

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 […]

Constant sets

To establish a view for the individual income tax rate […]

Progressive queries

Count the people in the Sales department; how many of t […]

Record set storage

Firstly, count the employees in the R&D department […]