Project Part 2.sql - USE university - Q1 SELECT student...

USE university;
-- Q1
SELECT student_fname, student_lname, DATE_FORMAT(dob, '%M %e, %Y') AS "Sept
Birthdays"
FROM student
WHERE MONTH(dob) = 09
ORDER BY student_lname;
-- Q2
SELECT student_lname, student_fname, FLOOR(DATEDIFF('2017-01-05', dob)/365) AS
"Years",
FLOOR(MOD(DATEDIFF('2017-01-05', dob), 365)) AS "Days",
CONCAT(FLOOR(DATEDIFF('2017-01-05', dob)/365), " - Yrs, ",
FLOOR(MOD(DATEDIFF('2017-01-05', dob), 365)), " Days") AS "Years and Days"
FROM student
ORDER BY years DESC;
-- Q3
SELECT student_fname, student_lname
FROM student
JOIN student_has_section
ON student.student_id = student_has_section.student_id
JOIN section
ON section.section_id = student_has_section.section_id
JOIN faculty
ON faculty.faculty_id = section.faculty_id
WHERE fname = 'John' AND lname = 'Jensen'
ORDER BY student_lname;
-- Q4
SELECT fname, lname
FROM faculty
JOIN section
ON faculty.faculty_id = section.faculty_id
JOIN student_has_section AS enrollment
ON enrollment.section_id = section.section_id
JOIN student
ON student.student_id = enrollment.student_id
WHERE student_fname = "Bryce" AND section.term_id = 2
ORDER BY lname;
-- Q5