CST363 - Week 2

1.  Example where joining on something other than keys would be needed.

Find the students who received grades more than 3.0 in the course "Math" and "Finance" and show their names and grades.

SELECT s.name, s.grade

FROM student as s

JOIN course as c

ON s.course_id = c.course_id

WHERE c.course_title IN ('Math', 'Finance') AND s.grade > 90;

2. My thoughts about SQL

I really enjoy learning SQL because working with databases and tables is something that’s easier to imagine and understand. It’s like organizing data in a structured way, which makes it more logical. SQL gives you the flexibility to query and manipulate data to find exactly what you need.

However, some queries can be complex, especially when dealing with subqueries and nested queries. It takes time to understand how they work and how to structure them correctly to get the desired result. Despite this challenge, I find SQL to be a very useful and powerful language for managing data, and I’m looking forward to improving my skills with more practice.