[SQL] Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)

https://www.youtube.com/watch?v=_vxobA36UN4

 

AVG

SELECT grade_level, AVG(gpa)
FROM students 
GROUP BY grade_level;

 

LIMIT

SELECT student_name
FROM students
LIMIT 5;

 

DISTINCT 

SELECT DISTINCT gpa 
FROM students
ORDER BY gpa;

 

LEFT JOIN

SELECT *
FROM students LEFT JOIN student_grades
	ON students.id = student_grades.student_id;