SQL

Notices where this attachment appears

1. cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:33 JST cyberpunklord420

   in reply to

   @hazlin Honestly, SQL is “deceptively simple” for a visual learner like me; I’ve had fewer trip-overs with Javascript because it visually displays animations to me in a way that makes sense, for the most part. :awoo_think:

   SQL is not supposed to be that hard because it’s just a way of querying data, so it has limited commands. But for some reason, I’ve been struggling in this course a lot by myself.

   This is Unit 3 Lesson 2 Project of Khan Academy, I’m using this data to practice: https://gist.github.com/pamelafox/26b9357c6120d3d0d27c2b90c950e8c6

   In the first picture, it’s just max, min, and average. Simple enough.

   The second one, was difficult and I couldn’t write it by myself - my husband wrote it and explained it to me instead. Basically, I have to think about what I want displayed in my columns, and write them first, then write where to get the data from, and THEN write any additional filters last. It’s… A different sequence of logic than what I’m used to, so because of that I also had a really difficult time of knowing what goes where.

   And the last one I did by myself - with how you use CASE in SQL, ppl structure it in a way that makes it easier for me to understand, so that overall wasn’t too hard.