What are the names of the high schoolers and how many friends does each have?
SELECT T2.name ,  count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id
SELECT T2.name ,  count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id
[{'name': 'Haley', 'count(*)': 1}, {'name': 'Alexis', 'count(*)': 2}, {'name': 'Jordan', 'count(*)': 1}, {'name': 'Austin', 'count(*)': 1}, {'name': 'Tiffany', 'count(*)': 1}, {'name': 'Kris', 'count(*)': 2}, {'name': 'Jessica', 'count(*)': 1}, {'name': 'Jordan', 'count(*)': 2}, {'name': 'Logan', 'count(*)': 1}, {'name': 'Gabriel', 'count(*)': 2}, {'name': 'Cassandra', 'count(*)': 1}, {'name': 'Andrew', 'count(*)': 3}, {'name': 'Gabriel', 'count(*)': 1}, {'name': 'Kyle', 'count(*)': 1}]