Константин Цветков

select u.name user_name, 
	     u.phone user_phone, 
	     sum(o.subtotal) orders_sum, 
	     avg(o.subtotal) orders_avg,
	     MAX(o.created) last_order_created
  from users u
  inner join orders o on o.user_id = u.id
  group by u.name, u.phone

SELECT (SELECT COUNT(*)
          FROM sp
          WHERE ([some] = 1)) AS SomeCount,
       (SELECT COUNT(*)
          FROM sp
          WHERE ([some] = 1) AND (noone = 1)) AS NooneCount

следует подождать?

DECLARE @TXT VARCHAR(MAX) = 'Этот красный мяч был синий велосипед'
DECLARE @FROM VARCHAR(MAX) = 'Красный'
DECLARE @TO VARCHAR(MAX) = 'Синий'
SELECT TRIM( SUBSTRING( @TXT, 
                        CHARINDEX( @FROM, @TXT ) + LEN( @FROM ), 
                        CHARINDEX( @TO, @TXT ) - (CHARINDEX( @FROM, @TXT ) + LEN( @FROM ))))

SELECT `p`, * FROM catalog_ads  
WHERE status = 1 AND category_id = 1 AND moderation = 0 AND ad_diamond = 0 AND ad_vip = 0 
UNION  
SELECT `v_p`, *  FROM catalog_ads
WHERE status = 1 AND category_id = 1 AND moderation = 0 AND ad_vip = 1
UNION  
SELECT `d_p`, *  FROM catalog_ads
WHERE status = 1 AND category_id = 1 AND moderation = 0 AND ad_diamond = 1 
ORDER BY 1 DESC

он ищет отдельными словами

CONCAT_WS( ' ', ' ', name1, name2, name3, ' ' ) LIKE '% Иван %'
AND
CONCAT_WS( ' ', ' ', name1, name2, name3, ' ' ) LIKE '% Иванович %'
AND
CONCAT_WS( ' ', ' ', name1, name2, name3, ' ' ) LIKE '% Иванов %'

ВЫБРАТЬ пользователь, КОЛИЧЕСТВО(*) 
ИЗ …
ГРУППА пользователь, продукт
СОРТИРОВКА количество СНИЖЕНИЕ ТОЛЬКО 1 СТРОКУ