Hi Jeff,

Thanks for commenting. At this point I don't, but I haven't put Dwain's code in production. One of my principles of the help I get on this forum is...

Thanks again, Dwain. That is super helpful. I was inner joining on the date column, and while it didn't leave NULLs, it also kicked out several rows (whereas my left...

I LOVE the solutions you all provided! Thanks a ton for the help! I'm learning a lot from playing with what you all wrote in my test environment. Super helpful.

Dwain,...

Okay, two posts above does have the correct dataset (which was the original dataset). I was confused for a moment whether the median in a quartile included the two averaged...

EDIT: On review, the original dataset above is correct. I really apologize for the confusion. I'll put in back in when I get back to my office.

Thanks a ton, Dwain.

Just for background (may not be needed) here are a couple of links regarding the math for box-and-whisker charts (or box plots)

http://www.purplemath.com/modules/boxwhisk.htm

https://www.khanacademy.org/math/probability/descriptive-statistics/Box-and-whisker%20plots/v/box-and-whisker-plots

Essentially, I need five things: median,...

I'm just going to bump this because I rewrote the above post and added what I've got to date...

Okay, using Dwain's suggestion I'm close to getting everything working. My only problem is the row_number in my inner query isn't working well when the numbers are the same. For...

Below another attempt, but I seem to be running into the same problem. For instance, 2012-03-01 should produce 90.5, but the below gives me 89.25.

SELECT

CourseDate,

AVG(CAST(Grade AS Numeric))

FROM

(

SELECT

CourseDate,

Grade,

ROW_NUMBER() OVER (

PARTITION...

Alright, its time to confess I'm still not getting this. Would anyone mind taking my original DDL and calculating median and lower/upper quartiles? I think if I can see it...

Actually, I'm having some trouble converting over the example to my sample table above. I just took the grades for 03-01-2012. The median should be the average between 90 and...

Awesome. Thanks a ton!

Bump.

Just thought I would check one more time.

Again this is really helpful. I hope you all won't mind a follow-up question:

What is the difference between...

WHERE [column] IN ([subquery])

and

WHERE EXISTS ([subquery])

?

I've been trying to read on it...

I really apologize for the typo! Typo notwithstanding, you guys gave me exactly what I was looking for. Thanks alot for the help!