SQL Query Questions and Answers

Question

SQL Query Questions and Answers

carlton 84646

SSC Eights!

Points: 902
More actions
June 4, 2022 at 8:17 am

#4044188
Hi Community,
Can someone provide some helpful links to where I can find SQL Query Questions on certain industries.
For example, there is a book called "Query Answers with SQL Server", by Adam Aspin & Karine Aspin. This book gives lots of Sample Query questions on the Automotive Industry. I was wondering someone could help point me to a site which provides similar SQL Query questions on various industries?
- This topic was modified 2 years, 4 months ago by carlton 84646. Reason: update question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 1

You'd have better luck with the following search in your favorite search engine. I didn't look at the specific articles themselves but I replaced the XXXXXXXXX with "mortgage", "automotive", and "food service" and the titles seemed to be pretty interesting. Here's the search...

SQL for the xxxxxxxxx industry

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 2

I have to say, I find this a little odd. I worked in the insurance industry for ten years. However, I worked for a fairly unique organization. We had almost all hand-built databases. There's no way a "here are insurance SQL queries" list would work for us at all. Our tables were not remotely the same as other insurance companies. I'm not saying we were 100% unique, because lots of the problems are somewhat common. I am saying our data structures were not some standard upon which all insurance companies operate. Having done work for Jaguar motor cars quite a few years back, I'd say the same there. Banking also, 10 years with Merrill and consulting with a couple of other banks. While there is lots of common problem spaces, so the logic within an industry is similar, the structures are so very different, I just can't imagine something like this working well.

Maybe it's just me.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

carlton 84646 SSC Eights! Points: 902 More actions · Answer 3

Grant,

This is a perfect response.

I would say that I can get typical industry queries from LeetCode, Hackerrank, StrataSearch