By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE orders ( id INT, userId INT, tripType varchar(255) );
INSERT INTO `orders` (`id`, `userId`, `tripType`) VALUES
(1, 1, 'way'), (2, 2, 'way'), (3, 3, 'way'),
(4, 1, 'on-road'), (5, 2, 'on-road'), (6, 3, 'way');
SELECT * FROM orders;
Records: 6 Duplicates: 0 Warnings: 0
| id | userId | tripType |
|---|---|---|
| 1 | 1 | way |
| 2 | 2 | way |
| 3 | 3 | way |
| 4 | 1 | on-road |
| 5 | 2 | on-road |
| 6 | 3 | way |
SELECT userId, COUNT(*) totalOrders FROM orders GROUP BY 1
| userId | totalOrders |
|---|---|
| 1 | 2 |
| 2 | 2 |
| 3 | 2 |
SELECT userId, tripType, COUNT(*) totalOrderByTripType FROM orders GROUP BY 1, 2
| userId | tripType | totalOrderByTripType |
|---|---|---|
| 1 | way | 1 |
| 2 | way | 1 |
| 3 | way | 2 |
| 1 | on-road | 1 |
| 2 | on-road | 1 |