GROUP BY

Exercise #70

Database «Ships»

GROUP BY clause

Getting summarizing values

Simple SELECT statement

SELECT statement

CASE statement in GROUP BY clause

About the use of the operator CASE

Exercise #37

Database «Ships»

Exercise #59

Database «Recycled materials company»

HAVING clause

Getting summarizing values

CASE statement in HAVING clause

About the use of the operator CASE

Exercise #(-2)

Database «Ships»

Exercise #27

Computer Firm Database