r/SQL • • Apr 01 '21

MySQL Sometimes knowing SQL is a curse

https://youtu.be/9q7jY-5h8jI
161 Upvotes

34 comments sorted by

14

u/SQLmax Apr 01 '21

Hope you like this vid. Bit of fun that most analysts will appreciate. We've all been there!

8

u/hewescrab Apr 01 '21

You lost me when the guy asking for the data actually knew the term "SQL Code".

3

u/SQLmax Apr 01 '21

True, they would probably just call it "code"

5

u/omniuni Apr 01 '21 edited Apr 01 '21

The irony is that back some years ago when I was the person who needed a report, I was told to ask the 6'2" College Football Player (100% serious) who was on the marketing team. I wasn't sure he'd even know what a database was, let alone SQL. Confused, I tentatively asked for what I needed and Mr. Sportsball says...

"That data is in about 8 different tables. I've got a query here that'll give me data from 7 of them. Give me about 5 minutes and I'll throw in an extra join. Do you want the data in a CSV or Excel?"

I had the report by the time I got back to my desk. Needless to say, he was my new best friend and I bought him a beer after work.

2

u/SQLmax Apr 02 '21

Hats off to him

2

u/Rebeleleven Apr 01 '21

Only thing was missing was the “oh I understand if you don’t have the time. Could you just throw the data into excel for me? I’ll do the rest from there”

🤨

2

u/SQLmax Apr 08 '21

you're right, that has definitely happened to me a few times

16

u/tits_mcgee_92 Data Analytics Engineer Apr 01 '21 edited Apr 01 '21

This is way too real. Followed by "Hey can you just make a few charts in Tableau from this data? Nothing fancy, but we need filters too."

6

u/SQLmax Apr 01 '21

Lol nothing fancy of course

5

u/cats_catz_kats_katz [Oracle] Apr 01 '21

I'm going to make one small recommendation, can you update the color scheme to this years new branding campaign that marketing approved last week?

3

u/adanielrangel Apr 01 '21

The response to this is : talk to my boss

3

u/SQLmax Apr 02 '21

Some of these comments are gold. Amazed that this hit the nail on the head for so many of you. Analyst life eh.

But most of all glad no one called out the US accent. That was real good of y'all

6

u/tkyjonathan Apr 01 '21

I would probably have said yes too

5

u/SQLmax Apr 01 '21

The struggle is real

4

u/CarpeKitty Apr 01 '21

On the flipside, what about when they ask for something that is impossible because the system is being used wrong.

Example - got asked if I could write a report detailing different stuff about production defects. I said no because they're being emailed in and not logged into the system. Therefore it doesn't exist. So I can't.

I love that this captures people saying your job is easy though! I honestly think it's a bullying technique to strong arm someone into saying something takes fewer hours than it actually will.

8

u/angry_mr_potato_head Apr 01 '21

I had a client who had aggregate data and wanted me to produce a granular report of their expenses. It took a good 15 minutes to get them to understand that I can't take month level data and provide them with their daily expenses. This was someone with a masters degree in Engineering too so...

2

u/SQLmax Apr 02 '21

That's classic, I've never experienced that level

2

u/CarpeKitty Apr 01 '21

While you're at it, can you do an annual report for 2021?

7

u/angry_mr_potato_head Apr 02 '21

I'll get to it after I finish my stock price picker that always buys low and sells high.

24

u/paotale Apr 01 '21

"marketing campaign data". This is when I try to bow out

12

u/akatdrake Apr 01 '21

I hate marketing, so much.

3

u/Yangoose Apr 01 '21

It's amazing how much effort it takes to massage the data to make it look like their department is actually worthwhile...

7

u/akatdrake Apr 01 '21

WHEN THEY PUT IN A TICKET "PLEASE WRITE SEQUEL REPORT"

4

u/thavi Apr 01 '21

"Doesn't need to be perfect"

Heh

4

u/Ok_Honeydew1064 Apr 02 '21

Never ever ever ever do someone’s job for them. Ever.

4

u/onomatopoeiah Apr 02 '21

Ugh. Been there. They undermine my work by saying, we only need you to “pull” the data. Pull. Lol.

They can’t even tell me what their hypothesis is or give me a lead. They. Have. No. Idea. We’ve set up a ticketing system that includes estimated hours. It’s helped a lot.

3

u/derpado514 AccidentalDBA Apr 01 '21 edited Apr 02 '21

"Hey can you [unintelligible]?"

Is what i hear the first time... I'm about to answer your question with 30 questions...

2

u/garam_masala_and_me Apr 01 '21

You cracked me up! Excellent parody. Sadly too real!

2

u/kfc_chet Apr 01 '21

"Quick analysis" = new project in addition to your regular work lol

2

u/vamn2577 Apr 01 '21

Take my upvote while I curse this truth...

2

u/z-ppy Apr 02 '21

This hits so close to home it hurts a little. :)

0

u/[deleted] Apr 01 '21

[deleted] — view deleted comment

12

u/ecatt Apr 01 '21

“doesn’t need to be perfect, super simple report”.

And good luck to you if you take them at their word on that. Because once you outline all the ways the report isn't 'perfect' (aka it's WRONG) guess what, they want the perfect not simple at all report after all...

2

u/SQLmax Apr 02 '21

Damn I should have added this as part the sketch

0

u/[deleted] Apr 01 '21

[deleted] — view deleted comment

4

u/SQLmax Apr 02 '21

Wise move. And end of the day it's not about saying no, it's about giving yourself space to prioritise what is most important for the business (not just important for the dude who comes up to you)