Company interview questions, the great god answer:

CodePudding user response:

 SELECT LEFT (charge date, 8) AS the date, 
AVG (total amount) AS per 
The FROM SF_BRJSK 
GROUP BY LEFT (charge date, 8) 
The ORDER BY the date 

CodePudding user response:

The above answers to dead, but don't write SQL

CodePudding user response:

I won't write, is probably the first daily averages out, and seeking their cartesian product