I’m struggling with complex queries in SQL. Does it really get easier?

I’m completing a course on DataQuest, and there’s one particular problem as part of the end project that I’m really struggling with.

It honestly seems kind of impossible.

I just can’t in my mind visualise or understand how I would get form A to B.

I’ve seen a lot of people say SQL is easy. If they are talking about basic SELECT and JOINs, then yes, I would agree. But actually having to create several subqueries, implement CASE and EXCEPT operators, and produce some summary statistics is proving really difficult.

I’m just wondering if I’m going about this the wrong way, or if I need to train my brain to think differently.

It’s disappointing because I considered myself quite good with Python, and would like to go on to be a Data Engineer. But now I just feel inadequate being unable to solve this question.

submitted by /u/RedditorGuyAbc
[link] [comments]


Go to Source of this post
Author Of this post: /u/RedditorGuyAbc
Title Of post: I’m struggling with complex queries in SQL. Does it really get easier?
Author Link: {authorlink}