| select | |
| count(*) over pos_win `count`, | |
| sum(salary) over pos_win `sum`, | |
| row_number() over pos_win `row_number`, | |
| rank() over pos_win `rank`, | |
| dense_rank() over pos_win `dense_rank`, | |
| cume_dist() over pos_win `cume_dist`, | |
| percent_rank() over pos_win `percent_rank` | |
| from dfs_test.`%s/window/%s` | |
| window pos_win as %s |