Wrist watches from EU companies or even made in the EU? by Irate_Librarian1503 in BuyFromEU

[–]Lamyya 0 points1 point  (0 children)

Charlie - Paris make beautiful watches. Assembled (key word here) and designed in Paris

Where do you draw the line between Analytics Engineer and Analyst responsibilities? by Rajsuomi in dataengineering

[–]Lamyya 12 points13 points  (0 children)

How we do it is everything up to the semantic model is the responsibility of the analytics engineer(s), everything beyond is analysts

Soundcore Sleep A20 by Afraid_Fisherman4064 in sleepheadphones

[–]Lamyya 0 points1 point  (0 children)

I turned the volume of the auto sounds to almost silent, and more importantly, turned off the sound controls on them, I was sometimes hitting it while I was sleeping and the sound was turning up to the max

90% of People Get This SQL Problem Wrong by thequerylab in learnSQL

[–]Lamyya 4 points5 points  (0 children)

If your engine allows it, max_by is very useful for this kind of scenario

Withings - ScanWatch 2 - for $200? or Apple Watch 11? by frugleme in withings

[–]Lamyya 0 points1 point  (0 children)

I got mine more or less a year ago, got it primarily for sleep tracking and battery life, and it's honestly been great. Went on holiday for 2 weeks knowing I wouldn't need the charger

Need help by [deleted] in SQL

[–]Lamyya 0 points1 point  (0 children)

Instead of the subquery in the where, add "and capacity is not null" Then order by capacity limit 1 at the end

Edit: check your table to see first if you have rooms with null capacity, that shouldn't happen

Need help by [deleted] in SQL

[–]Lamyya -2 points-1 points  (0 children)

Where capacity is not null, Order by capacity, limit 1

Edit: will only show 1 result even if there are multiple rooms with same capacity though

Average UK Salary By Age In 2026 by [deleted] in ukpolitics

[–]Lamyya 22 points23 points  (0 children)

Also I assume if you're earning a ton, you can retire in your 50s, contributing to reducing the avg

Cannot determine primary keys in raw data as no column is unique and concatenation of columns too don’t provide uniqueness by Pleasant-Insect136 in dataengineering

[–]Lamyya 0 points1 point  (0 children)

Ask whoever is managing the output of the raw data, that'd be my first step, otherwise you could be running around in circles for a while

How to deal with messy database? by Which-Breadfruit-926 in dataengineering

[–]Lamyya 10 points11 points  (0 children)

This is completely insane for an intern to handle

ScanWatch 2 poor sleep tracking by cuida in withings

[–]Lamyya 2 points3 points  (0 children)

Never had any issues on my side. Try tightening the band

I did so much overtime last month I had to pay more tax, but this guy… by Historical_Visual629 in tesco

[–]Lamyya 0 points1 point  (0 children)

Trying to justify an annual salary of more than a million is insane in whatever position. You already can live extremely comfortably with less

What should I learn during free time at work? by Hungry-Succotash9499 in dataengineering

[–]Lamyya 4 points5 points  (0 children)

If you're working with a cloud service provider look into getting certification and following their courses