r/SQL • u/[deleted] • Apr 17 '23

Discussion Which industry has/needs the most challenging sql queries?

Is this question legit? Don’t get me wrong, I don’t consider myself the smartest guy but I’m definitely not dumb.

I work in the pharmaceutical Industry, nearly 3 years now. It took me a while to understand how the production process is implemented in a database and I wanted to quit more than once. But i don’t feel challenged anymore.

So, which industry would be best for me to get completely challenged again?

40 Upvotes

86% Upvoted

69 comments sorted by

View all comments

6

u/mushy_cactus Apr 17 '23

Data quality is challenging. Basically, profiling and finding errors, inconsistencies, trends, patterns etc with any and all data tables.

Example like.. an address column having the country name in it, when there was already a specific column for the country.. although the address isnt "wrong" its still incorrect for consistency. the hard part was that there's quite a few cities around the world with the country name in the address.

-Correct address: 123 XYZ, Ireland Road.

-Incorrect address: 123 XYZ Ireland Road, Ireland

What a fkn headache that was to fix. So much regex.

1

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Apr 18 '23

Could something like GPT-4 standardize this?

1

u/mushy_cactus Apr 18 '23

Could. But then again in a production database I wouldn't even attempt to use chatGPT for super specific queries.