COUNT

Exercise #70

Database «Ships»

GROUP BY clause

Getting summarizing values

Numbering of rows in accordance with the order of values of a primary key

Numbering of a query result set

Exercise #37

Database «Ships»

Exercise #(-2)

Database «Ships»

Getting summarizing values

SELECT statement

CASE statement

SELECT statement

Exercise #(-2) (tips and solutions)

Tips and solutions