**NTH_VALUE Syntax:**

```sql

NTH_VALUE(column, N) OVER (

[PARTITION BY partition_columns]

ORDER BY order_columns

ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING

)

-- Examples:

NTH_VALUE(salary, 1) -- Highest value (same as MAX)

NTH_VALUE(salary, 2) -- Second highest

NTH_VALUE(salary, 3) -- Third highest

```

**NTILE Syntax:**

```sql

NTILE(number_of_buckets) OVER (

[PARTITION BY partition_columns]

ORDER BY order_columns

)

-- Examples:

NTILE(4) -- Quartiles (4 equal groups)

NTILE(10) -- Deciles (10 equal groups)

NTILE(100) -- Percentiles (100 equal groups)

```

**PERCENT_RANK and CUME_DIST Syntax:**

```sql

PERCENT_RANK() OVER (

[PARTITION BY partition_columns]

ORDER BY order_columns

)

CUME_DIST() OVER (

[PARTITION BY partition_columns]

ORDER BY order_columns

)

```

**Practical Examples:**

```sql

-- 1. Statistical analysis of sales data

SELECT

salesperson,

monthly_sales,