Determine the average date of birth for users associated with each shop.

SELECT shop_name, AVG(shop_merchant_user_date_of_birth) AS average_date_of_birth
FROM order_transaction.transaction_detail_deprecated
GROUP BY shop_name;