Syntax error.

If i do:

SELECT MAX(Revenue_Spend) AS "Largest Amount Spent" FROM MaxCents

I get the max amount spent, but I can't figure out how to get it to display the...

Hmm .. maybe something like :

SELECT userID as "Highest Spending User", MAX(Revenue_Spend) as "Amount Spent"

FROM MaxCents

...?

- I want to show every day, even if there isn't a row for it.

- Don't have much experience with CTE ... the syntax should be something like

WITH...

This isn't homework. It's a SQL workstream for a company I just joined (already told them during the interview process I wasn't that strong on SQL). I wanted to try...