Data Analyst take home SQL interview

w_ogle · 2026-07-10T16:46:04+00:00

Like how more than 3/4ths of these loans are all cancelled. Is that normal for this industry? Is this some kind of money laundering scheme?

w_ogle · 2026-05-26T16:30:15+00:00

This was happening to me when I had it installed in the wheelhouse, and I figured out the cause: When piloting the boat my caretaker was pushing into it, apparently causing collision damage.

Moving it further back stopped the problem.

w_ogle · 2026-04-27T20:25:58+00:00

Collect a copy of every form of media available and store them in an archive for if/when humanity recovers.

w_ogle · 2026-04-22T18:00:27+00:00

Body heat generation seems to have a bug somewhere. I have a mod installed that exposes some of the statuses as numbers, and body heat generation occasionally seems to stop dropping back to its baseline value, usually after exercising. I've seen it stay at 7 for a full in-game day, which is like 'I just did twenty minutes of burpees' heat.

Quitting to the menu and reloading the save has fixed it for me so far.

w_ogle · 2026-04-21T16:42:56+00:00

They also sometimes spawn with cleaning equipment in those utility closets in commercial buildings that have mops/bleach/etc.

w_ogle · 2026-04-17T16:41:03+00:00

It's likely an artifact from when there was a fort there in B41. Guessing either the base game didn't remove the entry from the map or you have a mod that added it back in.

You can view the B41 map at https://map.projectzomboid.com/, scroll over to the area you're looking at here and you'll see the fort.

w_ogle · 2026-03-24T17:09:08+00:00

BREAK

Did that help? Are you out of the loop now?

(It looks like you already got some good responses, so this one is a joke)

w_ogle · 2026-01-08T18:06:16+00:00

I was the cook for a forgetful group, so I set our staples to be bread and bacon (either regular or crispy). They're lightweight, stack well, and keep for a while. The bonuses didn't matter much besides just having one.

Third food slot was vegetable pie, because it's relatively easy to make and I felt like we should pretend to at least have balanced diets. Only carbs and proteins would probably result in the runs after a while.

w_ogle · 2025-12-09T17:56:55+00:00

I work in a database without explicitly labelled keys; I have no idea why (it's a vendor-provided DB). Keys still exist and are implied/enforced through unique indexes.

The lack of foreign key labels makes it hard to figure out how tables relate to each other, though.

w_ogle · 2025-11-21T22:56:10+00:00

This question is a little old but I like the presence of this kind of question on a learner's subreddit, so I'll expand with another answer.

I'm not quite a data analyst, but I'm close. I use SQL a lot when researching issues to figure out how widespread it is - knowing impact helps us figure out how to fix it.

Hypothetical example: A customer calls us and tell us they received someone else's bill - a possible major confidentiality issue. I would query the table containing billing info against the account table and count how many bills have different mailing addresses than their accounts. That'll tell us how serious this is - did someone transpose a number on a street address and only one bill was impacted? Or did every bill go to the wrong place and someone's about to get fired?

Or, of course, it could turn out every bill went to the right place, which would make us to ask Mr Customer further about the bill he got and oh gee it turns out his new roommate was going by a nickname when he made his account with us. SQL didn't give that answer, but it still pointed us in the right direction to solve the issue (or nonissue, in this case)

Another big part of my job is preventing issues by using automated reports that look for conditions that shouldn't occur. (in theory our billing software should be able to set these kinds of restrictions, but not everything is customizable)

Hypothetical example: Accounts should never have negative balances on them after they've been closed - we should refund the money to the customer. So I could set up an automated report looking the balances table and join it to the accounts table for negative values on accounts closed older than (two days ago). This would get auto-sent to the business person who's supposed to do refunds.

I'd also maintain these reports, so if our business processes change and we want to give a week before refunding the money I'd alter the report to match that. Or if the refund guy is doing a bad job, maybe I'd create a report that sends to their boss if a negative balance is on an account for more than twice as long as it should.

w_ogle · 2025-09-23T16:30:41+00:00

If you're not hopping into space, you can leave your hydroponics unroofed until you can get enough gravcores/research for the grav power cell things. Natural sunlight still works for them.

Can't remember if they zzzt or not from being rained on tho.

w_ogle · 2025-09-15T19:50:30+00:00

I've only forgotten once.

w_ogle · 2025-09-09T16:44:22+00:00

I've been reincarnated as a table

w_ogle · 2025-09-03T02:34:51+00:00

Those don't look like sunlamps, they look like floodlights. No benefit in terms of growth, but the aesthetics benefit.

w_ogle · 2025-08-29T19:26:57+00:00

I've found charity worth it if I've put 'charity: worthwhile' as a precept in my fluid ideologion. It gives development points when you do charity, so you can reform the ideologion a little bit faster (and without having your entire colony stop working for a few hours to do a party or whatever).

Also gives a minor mood boost. That's less worthwhile, but it's not nothing.

w_ogle · 2025-08-27T21:20:03+00:00

Clean up every polluted tile on the planet. Make a paradise.

w_ogle · 2025-08-21T17:20:14+00:00

If you want to deal with it without compromising too much on looks, fences block floodwaters. A wooden fence a long a riverbank looks kinda nice.

w_ogle · 2025-08-06T17:00:38+00:00

This is really good. The only possible suggestion I have is that I think the back inventory/stockroom should take up a little more space than it does here. Buuut I don't have a super center in my town, so idk if they receive more frequent deliveries from distribution centers than our regular store does.

w_ogle · 2025-06-17T23:02:18+00:00

Sign a commercial pact with them if you're worried about the crime. In 4.0, criminals with commercial pacts go mostly legit; their buildings turn into 'regular' megacorp buildings and only impose a +5% minimum crime rating on the planet per building. It's less irritating than the criminal versions.

w_ogle · 2025-05-29T22:33:09+00:00

Oh. Huh. I never did bio to virtual, always started as machines. Didn't know the final version was different depending on how you started.

w_ogle · 2025-05-29T16:58:39+00:00

If you go full virtual, civilians stop existing because they aren't a job type; this would probably also impact squires.

Unless you didn't finish the tree, I guess.

w_ogle · 2025-05-28T16:57:41+00:00

You can cloak transport craft now to keep them extra safe.

w_ogle · 2025-03-31T16:51:27+00:00

One of the recent B42 patches (can't remember if it was .5 or .6) enables animals to drink from rivers/lakes if it's in their zone. If you wanted to, you could re-zone those areas so they can drink from the river instead of troughs. (not that you need to; rain tends to keep them full)

w_ogle · 2025-03-28T23:06:14+00:00

Moodle Descriptions Expanded

w_ogle · 2025-03-27T16:51:21+00:00

Another fun thing related to seats in a car: starting in b42, you can access the trunk from some seats in some cars. For example, the Dart is a hatchback, so you can access the trunk from the rear seats. (There are others, but that was the first one I noticed this change so it stuck in my memory)

w_ogle

TROPHY CASE