SQL trouble with average function

Question

I am very new to SQL and am having a lot of trouble wrapping my head around certain things. The following code

SELECT Treated.ProgScore, Patient.Ethnicity
FROM Patient
    JOIN City
        ON Patient.ZIP = City.ZIP
    JOIN Treated
        ON Patient.SSN = Treated.PSSN
WHERE City.Cname != 'Dallas';

produces the following data. I would like to extract the average ProgScore of each ethnicity and list it from lowest to highest average ProgScore

PROGSCORE ETHNICITY

---

     2 Japanese                                 
     5 Caucasian                                
     9 Caucasian                                
     2 African                                  
     3 Japanese                                 
     7 Caucasian                                
    10 Japanese                                 
     8 Caucasian                                
     1 African                                  
     4 Japanese                                 
     7 Caucasian                                

Is there a way to do this? I would like my output to look like this.

Average ETHNICITY

---

  4.75 Japanese                                 
   7.2 Caucasian  

Thanks for any help

Answer 1

It sounds like you want

SELECT avg(Treated.ProgScore), Patient.Ethnicity
FROM Patient
    JOIN City
        ON Patient.ZIP = City.ZIP
    JOIN Treated
        ON Patient.SSN = Treated.PSSN
WHERE City.Cname != 'Dallas'
GROUP BY Patient.Ethnicity
ORDER BY avg(Treated.ProgScore);