Sure!  What is the average enrollment of ASU and LSU?
SELECT avg ( enr )  from college where cName  =  "ASU" or cName  =  "LSU"
average enrollment = AVG(enrollment); enrollment refers to enr; ASU and LSU refers to filtering by cName = 'ASU' or cName = 'LSU';