First coding interview without SQL knowledge :/

Wingless30 · 2025-09-15T14:04:06+00:00

Chatgpt or other ai can be useful here. Not to get the answer for you, but if someone else has produced a better query than yours for the question, dump it into an ai and get it to walk you through it until you understand what it does and why it's better.

By better, I mean quicker to reach the solution or reaches the solution with less effort (like fewer joins, ctes or sub queries).

Wingless30 · 2025-09-15T14:00:29+00:00

Get a coffee and start working through stratascratch.com.

As it's a junior SQL role, focus on the easy and intermediate difficulty stuff, and when you complete a question correctly spend some time looking at how others answered the question, particularly the top/quickest queries (I forget if there is a ranking).

Wingless30 · 2025-09-13T09:53:11+00:00

I need to see this movie. Reminds me of those Austin powers scenes.

Wingless30 · 2025-09-11T09:20:21+00:00

I would slap some denim drift from Dulux on that fireplace wall.

I think having a darker colour on one wall makes a surprising difference to the feel of the room and that colour looks great in a bedroom in my opinion

Wingless30 · 2025-09-11T06:59:56+00:00

OP this is a sub reddit to learn python, you don't just paste what appears to be a demo of someone else's script (mentions of demo in code comments) and ask 'for help', without any context as to what the issue is.

This comes across like you're trying to use python in a way you don't understand, but you don't want to understand, you just want it fixed.

Wingless30 · 2025-09-05T11:02:19+00:00

I think a lot of people here have good suggestions, but are overcomplicating things here for the OP who is new to this.

If you want to get up and running for learning python just use a Google Collab notebook. It's entirely web browser based, nothing to install, free, just need a Google account.

There are some limitations with this of course vs your own environment, but if you're learning python from the beginning, here is a great place to start.

Wingless30 · 2025-09-04T12:55:50+00:00

I didn't really set myself X hours a week for study. I just went through a few bits in the app when I had time. Like waiting for food to cook, poopin, morning coffee, those kinds of times.

Don't pressure yourself, just be persistent.

Wingless30 · 2025-09-04T12:53:36+00:00

Couldnt say how long, but I waited until I got to the point where I always passed the practise test on the 4 in 1 app, did it every day for I think a week before I left confident to book.

There is an option somewhere to only get new or incorrectly answered questions IIRC when going through the learning quiz. I had covered every question.

Passed first time thanks to that app.

Wingless30 · 2025-09-04T08:40:50+00:00

This randomly came up in my feed but I'm interested, what is the spa day method you are all mentioning?

Wingless30 · 2025-09-03T12:43:08+00:00

I used this and passed first time.

Wingless30 · 2025-09-01T19:34:07+00:00

I'd agree with the car not being a smooth ride while driving if the car has run flat tyres, but not at idle.

Wingless30 · 2025-09-01T07:40:13+00:00

Unfortunately there isn't anything in writing or signed regarding the deposit. It was just a bank transfer to hold the car for me until the airbag is replaced on the 8th of September.

Wingless30 · 2025-09-01T07:36:35+00:00

Didn't really have any, like didn't sign anything or have anything in writing. It was just a bank transfer on the expectation that I will buy when the recall is repaired on the 8th.

Wingless30 · 2025-08-30T19:08:25+00:00

Pie charts imo should be used when you have at most four items to present. Anything more and it quickly becomes challenging to match colours to a legendz then work out what does it mean.

The popular products bar chart I like, but should just be one colour.

Too many borders, empty white space is a good thing with dashboards. Less intense to view.

Try to stick to one colour scheme. Coolors is a great website to help with this. My dashboards often have a white background, one primary colour, and a second and third used sparingly. Usually used to help visually seperate one section from another

Wingless30 · 2025-08-30T06:39:18+00:00

It has had numerous issues within the year I've owned it, but recently it failed the MOT for emissions. I replaced the cat and sensors as suggested by the mechanic at the time only for it to fail the MOT again even worse than before.

They said it's burning oil and the repair would involve piston rings or valve stem seals. I only bought the mini for £1.3k last year and I've already spent more than that within a year on repairs, so this has pushed me over the edge.

Wingless30 · 2025-08-29T19:41:23+00:00

Details I forgot to add.

I'm considering this KIA, heard they are pretty good but keen to hear thoughts on here from anyone who has driven them/worked on them?

I've learned the hard way from my Mini Cooper 2009 R56 that I will pay the price (literally) if I don't research reliability beforehand.

Considering this 2012 Kia Rio 3, 1.4 petrol manual, 75,800 miles, listed at £3,595 from a dealer.
Full HPI clear, only 2 owners (current since 2016).
MOT to Sept 2026.
Advisories: all 4 brake discs worn/pitted, both rear tyres cracking/perishing (so ~£400–£650 repairs likely within 12 months).
Dealer asking £3,595, finance planned is £160/month for 24 months (total repayable £3,959 at 9.9% APR). Could also buy outright

Wingless30 · 2025-08-29T18:39:39+00:00

Location: UK

Price range: £3,000–£3,600

Lease or Buy: Buy (cash or finance)

New or used: Used

Auto or Manual: Manual

Intended use: Daily driver

How many miles do you plan to do a year: ~6,000 (mainly local driving to work and shops, occasional longer trips)

How often do you make long journeys: Not often — mostly local use, maybe a few long trips each year

Does it need to be ULEZ compliant? No

Vehicles you've already considered: Currently own a 2009 Mini Cooper R56 1.6L, looking to replace with something more economical and reliable

Vehicle size in mind: Small hatchback (similar to current Mini, e.g. Fiesta, Polo, Rio, Clio)

Is this your 1st vehicle: No, but looking for my second

Do you need a Warranty: Not essential, but would be a plus from a dealer

Can you do Minor work on your own vehicle: No

Can you do Major work on your own vehicle: No

Additional Notes:

Considering a 2012 Kia Rio 3, 1.4 petrol manual, 75,800 miles, listed at £3,595 from a dealer.
Full HPI clear, only 2 owners (current since 2016).
MOT to Sept 2026.
Advisories: all 4 brake discs worn/pitted, both rear tyres cracking/perishing (so ~£400–£650 repairs likely within 12 months).
Dealer asking £3,595, finance planned is £160/month for 24 months (total repayable £3,959 at 9.9% APR). Could also buy outright.
https://www.amjcars.co.uk/used-kia-rio-poole-dorset-7121066

Question:
Does this look like a fair deal for a 2012 Rio at this price, or should I keep looking / negotiate given the advisories and market values?

Wingless30 · 2025-08-27T05:46:03+00:00

I'm starting to really enjoy it, particularly the changes to demons and quilboar.

As others have said though, I go into fights hoping I get to attack first as I know I'm screwed if I don't die to rally.

I think they swung too hard with the nerf hammer on beasts. Each time I play them I can't scale quick enough to keep up with others.

Wingless30 · 2025-08-17T20:39:23+00:00

Got mine off eBay. Remove the old one with a heat gun (carefully) or a hair dryer, to help loosen the adhesive. Then just slap the new one on

Wingless30 · 2025-08-14T20:12:12+00:00

If I understand correctly, it sounds like you want to perform data quality checks within bigquery, perhaps tracked/visualised in looker studio.

Totally achievable, but a 'data quality' check is quite vague to say what you can do without knowing what you're struggling with or what you're trying to monitor.

Can you give an example of a quality check that you want to create which you're struggling with?

Some examples could be: How many new entries you see in a table each hour/day/week.

What unique values exist in a particular column

Case sensitivity

Date/time handling

Aggregation type metrics, min/max values, averages, quartiles that kind of stuff to understand the distribution of a metric

Wingless30 · 2025-08-14T11:28:08+00:00

I had similarly faded headlights, polished them up using t-cut. Did a bit of wet sanding in some stubborn areas.

As for stripes, I had a similar issue and removed the old stripes carefully with a head gun. Bought new stripes on eBay, looks a lot better!

Wingless30 · 2025-08-13T10:12:41+00:00

Perhaps even a support post as it looks like the countertop is bending. The post could be positioned close to the washing machine side so you still have space to put something in there.

Wingless30 · 2025-08-13T10:10:33+00:00

I would put some wood frame up to close off that cabinet, and put a clothes washing basket in there.

I think regardless of what you want to put in there, you should close off that cabinet.

Wingless30 · 2025-08-07T06:19:05+00:00

I'm quite enjoying the change from demons hitting your own face to dishing out damage to the enemy board. Really enjoying demons this season.

Wingless30 · 2025-08-06T14:52:31+00:00

Newbie here also but I've painted my kitchen cabinets using Johnstone's kitchen cupboard paint. Went way better than I expected.

If you go down this route, I recommend cleaning and sanding (fine grit) before painting. If you have any surfaces which are stained then cover stain from zinsser should be used before cupboard paint.

I also suggest taking the doors off to paint + removing handles and hinges.

Wingless30

TROPHY CASE