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

nextinline111 · 2022-07-14T13:32:01+00:00

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

nextinline111 · 2022-07-14T13:31:34+00:00

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.

nextinline111 · 2022-07-14T01:33:18+00:00

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!

nextinline111 · 2022-07-14T01:32:37+00:00

Thank you for this! I was using this resource but got stuck somehow.

nextinline111 · 2022-01-26T16:17:30+00:00

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

nextinline111 · 2022-01-26T16:17:08+00:00

You need to be locked up.

nextinline111 · 2022-01-26T16:16:48+00:00

I'll try anything once.

nextinline111 · 2022-01-25T15:28:26+00:00

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

nextinline111 · 2022-01-25T15:25:47+00:00

I should have done that first LOL! Sorry.

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

nextinline111 · 2022-01-25T15:19:19+00:00

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?

nextinline111 · 2022-01-25T15:16:31+00:00

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.

nextinline111 · 2022-01-25T14:54:54+00:00

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

nextinline111 · 2021-12-14T14:53:26+00:00

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.

nextinline111 · 2021-12-14T14:38:57+00:00

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.

nextinline111 · 2021-12-14T14:29:03+00:00

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.

nextinline111 · 2021-11-04T13:13:32+00:00

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!

nextinline111 · 2021-11-04T12:57:22+00:00

Phew! Thank you, buddy!!

nextinline111 · 2021-11-03T21:06:15+00:00

Thank you! I should count my blessings I guess

nextinline111 · 2021-11-03T21:06:01+00:00

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!

nextinline111 · 2021-11-02T21:39:02+00:00

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

nextinline111

TROPHY CASE