SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS student
FROM student AS s INNER JOIN enroll AS e USING (stuId)
WHERE e.grade = 'A'
AND s.stuId IN (SELECT DISTINCT stuId FROM enroll WHERE grade = 'B+');

SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS student
FROM student AS s INNER JOIN enroll AS e USING (stuId)
WHERE e.grade = 'A'

INTERSECT

SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS student
FROM student AS s INNER JOIN enroll AS e USING (stuId)
WHERE e.grade = 'B+'

CREATE TABLE t10
(A INT);


CREATE MUSIC t10 (A INT);

CREATE TABLE t10 hello (A INT);

CREATE TEMPORARY TABLE  t3
AS SELECT * FROM student;

SELECT * 
FROM t3;

SET @minor = 'CSCI';

SELECT @minor;

SELECT *
FROM student
WHERE minor = @minor;


CREATE  TABLE  t5
AS SELECT * FROM student;


CREATE  TABLE  t8
LIKE student;

INSERT INTO t8
SELECT * FROM student;