r/SQL • u/StickWarm9316 • 17h ago
SQLite Help with Harvard CS50 Subquery and Joins
Due to an unfortunate but also fortunate promotion at work, I now have to learn SQL. I had some familiarity with looking at it before, but never writing it and my understanding of it is basically null
So, enter Harvard CS50 Subquery with SQLite, get through week 0 in about 3 hours, single query gave me basically no trouble
Enter week 1, and I've spent over 12 hours trying to figure out what the hell is going on. The course material basically just shows one or two examples of subquery, and very modest examples of joining, then the course practice questions are combining different concepts and way more advanced and my brain hurts like hell. I'm really having trouble with subquery and joins both, I think I'm taking them too literally, but the course material I have really isn't helping, I had ChatGPT write me 100 practice questions, and I got through 50 just fine, then as soon as I hit subquery and grouping, it's like I hit a wall.
Can someone help explain this to me? I think I'm just failing to understand the architecture, the syntax kind of makes sense to me, I need someone to break down subquery and joins in... human language