Adding an IF based comparison column
The query

SELECT Place, 
       AVG(Money)
FROM Table6
GROUP BY Place


gives us a place and average money for it.

The query

SELECT AVG(Money)
FROM Table6


gives us an average money over whole table. 

This 2 queries allows us to compare AVG for place and AVG for all (because there are more than 1 table we must add table alias to each field)

SELECT t6.Place, 
       AVG(t6.Money) avg_place,
       CASE WHEN AVG(t6.Money) &gt; subquery.avg_all THEN 'High'
            WHEN AVG(t6.Money) &lt; subquery.avg_all THEN 'Low'
            ELSE                                       'Equal' 
       END avg_rank
FROM Table6 t6, ( SELECT AVG(t6_1.Money) avg_all
                  FROM Table6 t6_1 ) subquery
GROUP BY t6.Place


And now we can to store the result in new table

CREATE TABLE Table7
AS
SELECT t6.Place, 
       AVG(t6.Money) avg_place,
       CASE WHEN AVG(t6.Money) &gt; subquery.avg_all THEN 'High'
            WHEN AVG(t6.Money) &lt; subquery.avg_all THEN 'Low'
            ELSE                                       'Equal' 
       END avg_rank
FROM Table6 t6, ( SELECT AVG(t6_1.Money) avg_all
                  FROM Table6 t6_1 ) subquery
GROUP BY t6.Place