Neste ponto, na consulta, o demonstrativo SQL contém uma cláusula HAVING: SELECT titles.pub_id, AVG(titles.price) FROM titles INNER JOIN publishers ON titles.pub_id = publishers.pub_id GROUP BY titles.pub_id HAVING publishers.state = 'CA' ...
Neste ponto, na consulta, o demonstrativo SQL contém uma cláusula HAVING: Copiar SELECT titles.pub_id, AVG(titles.price) FROM titles INNER JOIN publishers ON titles.pub_id = publishers.pub_id GROUP BY titles.pub_id HAVING publishers.state = 'CA' No Agrupar por coluna, selecionar Onde ...