Alias

BETWEEN

Create Databases and Tabl

DELETE

DISTINCT

GROUP BY

HAVING

IN Operator

INNER JOIN

INSERT

LIKE

NULL value

REMOTE CONNECTION

SELECT

UPDATE

WHERE

SELECT students.s_name AS Name,students.s_grade AS Grade,subjects.s_name AS Subject FROM students
INNER JOIN subjects ON students.ID = subjects.student_id;

-- # Name, Grade, Subject
-- Steve, 80, MATH
-- Melisa, 60, MYSQL
-- Larry, 65, ENGLISH
-- Richard, 90, PHP