Another syntax example

SELECT pub_id, sum(advance), avg(price)FROM titlesWHERE price >= 5GROUP BY pub_idHAVING sum(advance) > 1500and avg(price) < 20ORDER BY pub_id

Previous slide

Next slide

Back to first slide

View graphic version