How to use Group By and self-join to return min, max, open, and close daily price restult set?

Note: this solution may present some problems if your opening or closing entry has the exact same date/time value as another row (i.e. The transaction that came immediately after opening, or immediately before closing). To address this, I would suggest that you add a sequence number that is stored in a way that guarantees uniqueness, and increasing-with-respect-to-time.

If you do this, then you would use the sequence value in the place of dte to replace the open_date and close_date I've used as join fields in my example.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.