u/waremi

General opinions were not flattering. Despite Dan Rather losing his job for reporting on his National Guard service, most people I knew saw him as a Frat-boy under qualified for the role who got the job because he was a "legacy" with a name people recognized. This view did change over the course of his presidency post 9-11.

Funniest thing I've seen on the interweb all week!

I know. A goose just bullied my cat in Connecticut. (Every year, every year...) I wish we had something like this, but the dam Bald Eagles don't migrate.

I heard you have a ritual every August where you transfer all the hatred, malice, and animosity from the people of Canada into the Canada Goose population before they fly south for the winter and that is why you all are so nice an polite all the time.

Except when two cars are give or take arriving at the same time and have to decide who reached the stop sign first, or maybe who came to a full stop first, or some one that uses the road every day and understands the unwritten rules but the crossing traffic is someone that just moved here from South Carolina where those are totally different. None of those apply to this video of course, but yes, with enough traffic volume, give me a rotary any day.

Roll up refers to the aggregate functions: SUM, COUNT, MIN, MAX.

You have every data point for every person that lives in the U.S. and you want to isolate which media markets to advertise in to reach a target demographic. You can "roll up" a total # by state, and pick the top 10, or by county and pick the top 10, or by town and pick the top 10. In each case you can ORDER BY COUNT() Descending, and select the MAX(Media Market Viewed) but each roll up will result in a different list of where to spend your money.

There is no right answer here, but what vector you decide to roll up on makes a difference, and any details below that point, like town or race, or age are no longer available to you once you pick the base level.

SQL is about set theory. In order:

SELECT: What you want to see

FROM: the full data sets you are pulling what you want to see from

WHERE: the sub-set of data you want to work with (including/excluding stuff you don't care about or don't apply.)

GROUP BY: (optional) Your top level points of interest. Anything not here has to be rolled up (SUM(), COUNT(), etc...)

HAVING: (optional-only applies if GROUP BY is used) which of those top level groups you are interested in. (Same as WHERE but after everything has been rolled up.)

ORDER BY (Optional) what order you want to see everything in.

That's it. Never think of any single record when writing a SQL query. Always think of it as a Ven Diagram. i.e. this is everything I have and this is the subset I want to pull out of it and, if you are not interested in the detail, then from that sub-set I want to collapse and roll up totals by this.

Underrated comment here.

If it means something to you. Enough that you want it to be a part of you, that answers the question. Personally I took a beat when I saw the image. It is beautiful.

Great answer! Can you help me with entanglement? From your answer I am thinking a particle that is everywhere it could possibly be interacts with another particle that has an overlapping probability of being in the same general area, but still doesn't collapse all probabilities. So the tree is still falling?

Doesn't a particle in a quantum state that interacts with another particle entangle it's quantum state with the particle it interacts with? The wave function doesn't collapse at that point, just expands.

I graduated with a BS in Physics and a minor in philosophy. You are my kind of people. Both disciplines involve a quest for the "truth" of a thing. It is just the things that are different.

Given the other comments here it is also worth mentioning that there would be no way for the matter radio receiver to have any way of knowing that the transmission came from and anti-matter transmitter.

Only the Shadow knows.

I didn't know that you didn't know that he didn't know that but know I do.

My default these days is blame Elon Musk. But this one may be on Tim Cook.

5yo people ask the best questions. Even if it is just the same one over and over again.

Or just because why not?

Not a bad guess. Mine is she told her BF she was visiting her mother in Jersey when she was actually sleeping with his best friend around the corner and wants the big gas receipt as back up.

I was part of that effort. I appreciate this being included in this thread.

Correct. I was wrong on that. I have edited my response.

Actually 0.82 not 0.822. With standard rounding, 12.5 could be anything between 12.45 and 12.54 15.2 could be anything between 15.15 and 15.24

Edit: u\Underhill42 below is correct. (I've been out of this too long.) The zero in 0.82 does not count and the correct answer to 3 significant digits is 0.822. The rest of my analysis stands. Although now I would love for someone to explain to me why two of the four edge cases (.8277 and .8169) do not match .822.

12.50/15.20 = 0.8224

12.45/15.15 = 0.8218
12.54/15.24 = 0.8228
12.45/15.24 = 0.8169
12.54/15.15 = 0.8277

Most of those equal 0.82. 12.5 - 3 digits, 15.2 - 3 digits, 0.82 - 3 digits. (I was a little shocked the last one was 0.83) It can get tricky if some measurements are more accurate than others, the the base rule-of-thumb is the result is only as accurate as the least accurate variable in the equation.

Shish Kabob

Tell all the truth but tell it slant —
Success in Circuit lies
Too bright for our infirm Delight
The Truth's superb surprise
As Lightning to the Children eased
With explanation kind
The Truth must dazzle gradually
Or every man be blind —

Emily Dickinson