MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE   `orders` (
  `ShipRegion` varchar(6) 
) ;

INSERT INTO `orders` VALUES
(null),
(null),
('RJ'),
('RJ'),
('RJ'),
('SP'),
('NM'),
('NM');


Records: 8  Duplicates: 0  Warnings: 0


select * from orders;


ShipRegion


null

null

RJ

RJ

RJ

SP

NM

NM


SELECT ShipRegion,
      COUNT(*)
FROM orders
WHERE ShipRegion is not null
GROUP BY ShipRegion;


ShipRegion
COUNT(*)


RJ
3

SP
1

NM
2


SELECT ShipRegion,
       COUNT( ShipRegion)
FROM  orders
GROUP BY ShipRegion;


ShipRegion
COUNT( ShipRegion)


null
0

RJ
3

SP
1

NM
2


SELECT ShipRegion,
       COUNT(distinct ShipRegion)
FROM  orders
GROUP BY ShipRegion;


ShipRegion
COUNT(distinct ShipRegion)


null
0

NM
1

RJ
1

SP
1

ShipRegion
null
null
RJ
RJ
RJ
SP
NM
NM