SELECT u.user_id , u.email , SUBSTRING_INDEX(email, '@',-1)FROM users u ;SELECT o.order_no , o.created_at, SUBSTRING(o.created