Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE orders (
id int,
status enum('new','complete')
);
INSERT INTO orders (id, status)
VALUES
(1, 'complete'),
(2, 'complete'),
(3, 'new'),
(4, 'new'),
(5, 'new'),
(6, 'complete'),
(7, 'new'),
(8, 'new');
<?php
var_export(
$db::table('orders')
->get()
->countBy('status')
->pipe(
fn($coll) => $coll->put('count', $coll->sum())
)
->toArray()
);