I have the following query

In Mssql I have the followong query
Select Datepart (month, sales_transaction.transaction_date), count(*)
from sales_transaction
Group by Datepart (month, sales_transaction.transaction_date)

which I have converted to :

Select extract (month from sales_transaction.transaction_date), count(*)
from sales_transaction
Group by extract(month from transaction_date)

But I receive a complaint on line three any ideas ?

Didier