Query - Want the count of ID based on the LAST DATE it appears
So here's what i did --

For # 1:
I used the answer given here: need help with this query

For #2 Here's what I did:

CREATE VIEW MaxDateStockNo(StockNo, Date) AS
SELECT StockNo, MAX(Date)
FROM my_table
GROUP BY StockNo

Then I ran a second query
SELECT Date, Count(*)
FROM MaxDateStockNo
GROUP BY Date

Now Any idea how i can get both of these Querys into one so that the output is just Date, Query 1 Result, Query 2 Result?

Thanks!