just tell investors to look at adjusted net ebitda. you'll be fine, they won't even notice (sarcasm because you need this stuff spelled out for you)
It called the fully adjusted number “community adjusted Ebitda,” by which it subtracted not only interest, taxes, depreciation and amortization, but also basic expenses like marketing, general and administrative, and development and design costs. Those earnings were $233 million, WeWork said.
whenever I see [select distinct ... group by] , i know i'm in for some bs. the original code creator had some duplication/cartesians but never properly addressed it
I’ve done it a few times in the app I’m working with and had no idea DISTINCT was not the proper way to address it. I mean, it’s a standard feature, named « distinct », easy to use and it works. It’s on me that I didn’t run an explain on these queries, but it seems like an easy mistake to make.
Anyway I’ll happily fix these in my code on Monday.
Seeing distinct being abused in application code is pretty rare though. What gets me is seeing it in some ETL or data analyst's queries. That's the sign that you're about to spend the next hour unfucking a query with like 50 joins and no CTEs for organization, written by someone who has no understanding of the underlying schema.
What about what they described makes you think they’re not in control? It’s the same principle as a mercury switch thermostat; figure out what you want the system to do and then automate it so you don’t have to constantly screw with it.
Well technically Amazon/Google/Philips/whoever is in charge of turning on the lights. You just happen to be sending a message that you want your lights turned on, but next week they might ask for a little more personal information or they won’t turn on the lights.
Hence for example using a clip lead on the bare terminals to turn your HVAC on and off when you feel the need, rather than automating the maintenance of temperature by such unworthy means as a thermostat.
why do people use right joins. i'll never understand it. especially in this case you when you can just query purchases directly and joining to users is pointless.
A good planner is going to pick the best strategy however you order them, because it’s job is to give the results fastest no matter how you write the query (all things being equal).
Consider that there’s a unique index on one of the 2 columns. It’s almost certainly optimal to use that to find a single row and then execute your other filters no matter the order.
Maybe there’s a situation where you can adjust the filters so ones that remove the most rows with the least cpu cycles are first? I’m going to try to create an example to see if I can make it behave differently.
That's how Meta pulls you in, but reddit has always felt less user-focused than subreddit and comment-focused. Read a link, make some smalltalk about it asynchronously for a few hours, move on.
Reddit is probably among the least sticky social media sites because of it.
It may be less sticky from a social perspective, but its comprehensiveness is (was?) its strength to me. I often search Reddit for very specific questions about a range of subjects. That's what I come back to it for.
(Although it's been a while now; the user hostility is just too much).
>I did this with facebook and it obliterated my social connections.
Huh... I did this with Facebook and it basically changed nothing. I was forced to text my friends life updates, that was it.
Out of every social media site I've quit, Facebook seemed to have the lowest impact on my life(as long as I or my wife checked it every 1-3 weeks for Events).
It seems Facebook has an ability to make you feel popular without actually making you friends. I'd be skeptical of the 'friends' you make on Instagram. I've made a few over the last 6 years, but since quitting, I really only talk to 1-2 of them rarely.
It's not a problem with reddit. I've been there maybe 15 years and never had a single "friend". I rotate the accounts every year or so, not a big issue.
I would've agreed with you 5 years ago. However, my weak connections seem to have thinned themselves out—the people I'd only ever see on FB have gotten bored and stopped posting there. Everyone else, I have other means of contacting.
i don’t in my hometown and didn’t go to school near my home state.
old friends get harder to see every passing year. it’s just incrementally harder to stay in touch given the geographical distance. i do text and visit when i can
Are / were they really 'friends' though if doing so obliterated your connections? Most people tend to misclassify being friends with being open & friendly with another.
There’s nothing wrong with having acquaintances that aren’t close friends though. I always see this argument and don’t get it.
Yea, my “true” friends will contact me anywhere, but it’s nice to have a small network of people I know that I can invite to stuff or even better yet invite me to events and activities. They may also become close friends at some point.
Yes. Putting people through hoops and then going "were we really friends if you didn't do it for me, huh, HUUUUH?" is a "I'm the main character" mindset.
A friend recently deleted all his apps and he asks me I just email him if I want to talk. I'm just not gonna do that. I barely remember to email my work people.
> Yes. Putting people through hoops and then going "were we really friends if you didn't do it for me, huh, HUUUUH?" is a "I'm the main character" mindset.
Interesting point.
> A friend recently deleted all his apps and he asks me I just email him if I want to talk. I'm just not gonna do that. I barely remember to email my work people.
Oh. You have zero self-awareness. Got it.
Since you can't figure it out yourself -- you are doing that first thing in that second thing. Your poor friend.
> A friend recently deleted all his apps and he asks me I just email him if I want to talk. I'm just not gonna do that. I barely remember to email my work people.
If you put them below “work people”, they’re not a friend. Or rather, you’re not a friend.
Ah yeah man totally wanting to jump through hoops (email was just an example), installing shit like wechat, kik, tiktok etc is the same thing) totally makes me the 'main character.'
That's something this strategy helps to trim out. Who I want to talk to and jump through hoops for, and whom I don't.
especially on a programming forum. Knowing Python, SQL, and R has been hugely beneficial. I can read Ruby scripts and colleagues can talk me through JS without me ever writing those.
Would be surprised if knowing multiple spoken language didn't help at all!
