EmmanuelBett Emmanuelbett67

## fccproject-premierleagueanalysis.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                Emmanuelbett67
                / fccproject-premierleagueanalysis.ipynb
            
            
              Last active
              October 6, 2025 17:13
            
              
                FCCProject-PremierLeagueAnalysis.ipynb
              
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## core-set.sql
-- 1. Find the names of all students who are friends with someone named Gabriel.

SELECT H1.name
FROM Highschooler H1
INNER JOIN Friend ON H1.ID = Friend.ID1
INNER JOIN Highschooler H2 ON H2.ID = Friend.ID2
WHERE H2.name = "Gabriel";


-- 2. For every student who likes someone 2 or more grades younger than themselves, return that student's name and grade, and the name and grade of the student they like.
	-- 1. Find the names of all students who are friends with someone named Gabriel.

	SELECT H1.name
	FROM Highschooler H1
	INNER JOIN Friend ON H1.ID = Friend.ID1
	INNER JOIN Highschooler H2 ON H2.ID = Friend.ID2
	WHERE H2.name = "Gabriel";


	-- 2. For every student who likes someone 2 or more grades younger than themselves, return that student's name and grade, and the name and grade of the student they like.