PSQL - 在左连接后不返回空列

I want to do an aggregation that counts total sales amounts grouped by hour. I need to return all hours within the last 24 hours, regardless if they have sales or not, and include the sales that happened within that hour.I want to do an aggregation that counts total s