Using the [w3schools database](http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all), list order info for each country with following columns (see hint/notes in [] against each column) and sort the data in descending order by the TotalOrderAmount value.

• Country  

• OrderCount [number of orders for each country]  

• ItemCount [sum of all the product quantities for each country]  

• TotalOrderAmount [total order value for all the orders for each country, rounded to two decimal points] 
• AvgOrderSize [TotalOrderAmount / OrderCount, rounded to two decimal points]

I have the following skeleton but I'm stuck on how to group by country.. 
**EDITED - error 1: could not prepare statement (1 no such column:TotalOrderAmount)** 

```
SELECT 
s.Country, COUNT(od.OrderID) AS OrderCount, sum(od.quantity) AS ItemCount, ROUND(sum(od.quantity*p.price),2) AS TotalOrderAmount, Avg(TotalOrderAmount/OrderCount)

FROM    Suppliers AS s

JOIN    Products AS p 
    ON p.SupplierID = s.SupplierID
JOIN     OrderDetails AS od
    ON od.ProductID = p.ProductID
JOIN     Orders AS o
    ON o.OrderID = od.OrderID

Group by s.Country

```

Any help appreciated! Thank you