Correlated Subqueries

Running totals

Correlated subqueries

Other examples of using window functions

Window functions

LAG and LEAD functions

Window functions

Combination of detailed and aggregated data

Getting summarizing values

CROSS APPLY / OUTER APPLY

New sql features

Exercise #8 (tips and solutions)

Tips and solutions

EXISTS predicate

Conventional set-theoretic operations and the SELECT statement

Exercise #(-2)

Database «Ships»

Exercise #15 (tips and solutions)

Tips and solutions

Correlated subqueries

Typical problems

Relational division

SELECT statement