t1.id,

            SUM(t1.amount) AS amount,

            SUM(t1.amount > 0) AS amount_plus,

            SUM(t1.amount < 0) AS amount_minus

 

        FROM `my_table` AS t1

 

        WHERE (bla-bla-bla)

 

        GROUP BY CONCAT(t1.month_fix,'-',t1.year_fix)

 

        ORDER BY t1.month_fix ASC

 

SELECT

  t1.username,

  t1.fullname

FROM `USERS` AS t1

LEFT JOIN `LIKES` AS t2

ON t2.user_id = t1.id

WHERE t2.type_id = $id_записиси

 

 

SELECT t1.*

 

FROM `company` AS t1

 

INNER JOIN `specialization` AS t2

ON t2.company_id = t1.id

 

WHERE t2.specialization IN (1, 6(тут подзапрос на id специализаций целевой компании)) AND (t1.id<>12 (это id целевой компании, исключим его из выборки))

 

GROUP BY t1.id

 

HAVING COUNT(*) >= 2(тут подзапрос на количество специализаций у целевой компании)

 

SELECT t1.*

 

FROM `company` AS t1

 

INNER JOIN `specialization` AS t2

ON t2.company_id = t1.id

 

WHERE t2.specialization IN (SELECT specialization FROM `specialization` WHERE company_id = $cid) AND (t1.id <> $cid)

 

GROUP BY t1.id

 

HAVING COUNT(*) >= (SELECT COUNT(id) FROM `specialization` WHERE company_id = $cid)

 

ORDER BY t1.total_rating DESC

 

LIMIT 7