RETURN QUERY SELECT "id", "name" FROM "mytable" WHERE date BETWEEN t1 AND t2;
$q = $var1 ?? $var2;
$q = isset($var1) ? $var1 : $var2;
$var1 = false;
$var2 = 2;
$q1 = $var1 ?? $var2;
$q2 = $var1 ?: $var2;
var_dump($q1, $q2);
SELECT p.phone,
count(1) filter(where i.status=7 ) as saled,
count(1) filter(where i.status=3 ) as no_saled
FROM items as i
INNER JOIN phones as p
ON i.user_id=p.users
WHERE p.phone IN("7924445544", "8985545444")
GROUP BY p.phone;