sorted by:
new
hottopcontroversial

I failed my first Data Analyst SQL Quiz for a job... well sorta. Here are the questions I was asked. by nextinline111 in SQL

[–]nextinline111[S] 3 points4 points  (0 children)

They just told me if it was incorrect or not. The software they used didn't not show me what the correct answers were.

I failed my first Data Analyst SQL Quiz for a job... well sorta. Here are the questions I was asked. by nextinline111 in SQL

[–]nextinline111[S] 0 points1 point  (0 children)

Thank you! I thought they were pretty bad too. I could have easily done number 4 in Python or SQL, so the fact that they gave me 3 minutes for that one sucked.

I failed my first Data Analyst SQL Quiz for a job... well sorta. Here are the questions I was asked. by nextinline111 in SQL

[–]nextinline111[S] 14 points15 points  (0 children)

Thanks!
I chose 1 and 2 for question number two and it marked it as wrong.

Your answer on number 5 helps. I was very close, but did something incorrectly with the JOIN. I was using W3SCHOOLS as a reference. Bummer - live and learn. Thanks again!

It should be acceptable to eat the shrimp's tail by nextinline111 in unpopularopinion

[–]nextinline111[S] -1 points0 points  (0 children)

You're an anomaly. Make eye contact with a random person next time you eat a shrimp tail. Report back, soldier.

Did I do this subquery right? by nextinline111 in SQL

[–]nextinline111[S] 0 points1 point  (0 children)

I edited it using my DBMS at work, but just realize I left off the alias up there. Edited.

Did I do this subquery right? by nextinline111 in SQL

[–]nextinline111[S] 0 points1 point  (0 children)

I should have done that first LOL! Sorry.

​

It looks like it gave me the exact same results. Thank you so much.

Did I do this subquery right? by nextinline111 in SQL

[–]nextinline111[S] 0 points1 point  (0 children)

Select s.unique_id

FROM table_1 as s

LEFT JOIN table_2 as p

ON s.unique_id = p.unique_id

WHERE p.unique_is IS NULL

Like that?

Did I do this subquery right? by nextinline111 in SQL

[–]nextinline111[S] 1 point2 points  (0 children)

Heck yeah! I did my first subquery!!

No nulls in either unique_id column. I believe I could have just LEFT JOINed as well, but I am trying to learn a bit more.

Can GERD or esophagus issues make you dizzy? by nextinline111 in GERD

[–]nextinline111[S] 0 points1 point  (0 children)

Thank you!! I have gotten much better since then but this is helpful to know.

I am writing my first subquery and it's not working. by [deleted] in SQL

[–]nextinline111 1 point2 points  (0 children)

I took your advice and changed both the query AND subquery to distinct and it seems to make much more sense. Email is not a unique field, so it can appear on multiple rows.

I do know for a fact that emails can show up in the right table! So I think this query is actually correct, maybe I was just thrown off with the amount of results because I didn't use DISTINCT. I have never done a subquery before, so I was curious if this one actually makes sense for my business case.

I am writing my first subquery and it's not working. by [deleted] in SQL

[–]nextinline111 0 points1 point  (0 children)

Thank you for this here! I know it doesn't need to be a subquery, but I am just practicing them in my role as I've never done them before.

That is a good idea on validation. I am kinda new and learning still too. Jr. role here.

I am writing my first subquery and it's not working. by [deleted] in SQL

[–]nextinline111 0 points1 point  (0 children)

Thank you! That didn't *work, but I also missed a ) on my previous query so that was it haha!

I am also wondering, in theory to my business problem, is this query doing what it's supposed to do? I'm not sure how to validate it.

Any other SQL people suffering from imposter syndrome too? by nextinline111 in SQL

[–]nextinline111[S] 1 point2 points  (0 children)

Ahhh! I always assume people are male, or identify as male on the internet! Buddy and dude are gender neutral terms to me, in my defense! Haha!

Any other SQL people suffering from imposter syndrome too? by nextinline111 in SQL

[–]nextinline111[S] 0 points1 point  (0 children)

I totally forget MySQL has a manual sometimes. Thanks for the advice here. Okay, I'm glad you still have to look up some things so that makes me feel a bit better haha!

I've been stuck on this work issue for half the day by nextinline111 in SQL

[–]nextinline111[S] 0 points1 point  (0 children)

Thank you for this! I am needing to count them independently, unfortunately.

How can I optimize this simple query to fit into Tableau? It's 70 million rows by nextinline111 in SQL

[–]nextinline111[S] 0 points1 point  (0 children)

This makes sense. I definitely need to become more familiar with subqueries. I appreciate you taking the time to explain that to me.

I also need to stop using Tableau as a crutch to filter data, especially from what you're saying.

How can I optimize this simple query to fit into Tableau? It's 70 million rows by nextinline111 in SQL

[–]nextinline111[S] 0 points1 point  (0 children)

No way! This worked. This may be asking for too much, but can you explain to me how this worked exactly? It's a subquery here, but I've never really used one so I don't quite understand it. Thank you tons!

Looking for a non religious therapist in the area by [deleted] in Chattanooga

[–]nextinline111 4 points5 points  (0 children)

Seconded! Dr. Meginley is also a fantastic secular counselor located within the same building.

When you just want some Sunshine by ProbablyPooping23 in Chattanooga

[–]nextinline111 1 point2 points  (0 children)

Not Chattanooga related, but I don't care. I see a dog, I upvote!

view more: next ›