another query question

Hi,
How do you do this in Pubs?
Select the types of books that had an average price > $13.50
I can only go so far:
select type, avg(price) from titles group by typenospam
select type, avg(price) from titles
group by type
HAVING avg(price) >13
"nospam" <hello@.hotmail.com> wrote in message
news:TuOdnavPvLGCLciiRVn-hA@.giganews.com...
> Hi,
> How do you do this in Pubs?
> Select the types of books that had an average price > $13.50
>
> I can only go so far:
> select type, avg(price) from titles group by type
>

ANN: Updated version of SQL Server 2005 Books Online is available for download

The September 2007 update to SQL Server 2005 Books Online (English version)
is now available for download at
http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en.
It is also offered as an Optional update via Microsoft Update.
See the topic "New and Updated Books Online"
(ms-help://sql90/sqlwhtn9/html/0f2f37d8-fc81-40c5-9976-cab8bd0b44e9.htm) for
links to the new and revised topics.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
On Dec 1, 5:53 am, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
wrote:
> The September 2007 update to SQL Server 2005 Books Online (English version)
> is now available for download athttp://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00d...
> It is also offered as an Optional update via Microsoft Update.
> See the topic "New and Updated Books Online"
> (ms-help://sql90/sqlwhtn9/html/0f2f37d8-fc81-40c5-9976-cab8bd0b44e9.htm) for
> links to the new and revised topics.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
Thanks for the updation

ANN: Updated version of SQL Server 2005 Books Online is available for download

The September 2007 update to SQL Server 2005 Books Online (English version)
is now available for download at
http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en.
It is also offered as an Optional update via Microsoft Update.
See the topic "New and Updated Books Online"
(ms-help://sql90/sqlwhtn9/html/0f2f37d8-fc81-40c5-9976-cab8bd0b44e9.htm) for
links to the new and revised topics.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspxOn Dec 1, 5:53 am, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
wrote:
> The September 2007 update to SQL Server 2005 Books Online (English version)
> is now available for download athttp://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00d...
> It is also offered as an Optional update via Microsoft Update.
> See the topic "New and Updated Books Online"
> (ms-help://sql90/sqlwhtn9/html/0f2f37d8-fc81-40c5-9976-cab8bd0b44e9.htm) for
> links to the new and revised topics.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
Thanks for the updation