SELECT count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id WHERE T2.name  =  "Kyle"
How many friends does the high school student Kyle have?
create table Highschooler(
	ID int primary key, 
	name text, 
	grade int);
create table Friend(
	student_id int, 
	friend_id int,
	primary key (student_id,friend_id),
	foreign key(student_id) references Highschooler(ID),
	foreign key (friend_id) references Highschooler(ID)
);
create table Likes(
	student_id int, 
	liked_id int,
	primary key (student_id, liked_id),
        foreign key (liked_id) references Highschooler(ID),
        foreign key (student_id) references Highschooler(ID)
);
INSERT into Highschooler values (1510, 'Jordan', 9);
INSERT into Friend values (1510, 1381);
INSERT into Likes values(1689, 1709);
INSERT INTO Highschooler VALUES [(1510, 'Jordan', 9), (1689, 'Gabriel', 9)]
INSERT INTO Friend VALUES [(1510, 1381), (1510, 1689)]
INSERT INTO Likes VALUES [(1689, 1709), (1709, 1689)]