I want to select customers whose price is higher than the average price

In SQL, Please is this correct?

MySQL query for records that existed at any point each week

I have a table with created_at and deleted_at timestamps. I need to know, for each week, how many records existed at any point that week: