.headers ON
.mode column
.echo ON


-- find the GPA of smith
select name, avg(grade)
    from student, takes 
    where student.ssn = takes.ssn
    and name="Smith"
    group by name;

