MySQL 8.0

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

select version();


version()


8.0.30


CREATE TABLE tblsolar (
tanggal varchar(10),
supir varchar(10)
)
INSERT INTO tblsolar 
VALUES
('sqlDate', 'cboSupir'),
('test', 'test'),
('test', 'cboSupir'),
('test', 'cboSupir'),
('sqlDate', 'cboSupir')

Records: 5  Duplicates: 0  Warnings: 0


SELECT * FROM tblsolar


tanggal
supir


sqlDate
cboSupir

test
test

test
cboSupir

test
cboSupir

sqlDate
cboSupir


SELECT 
  (SELECT 
   COUNT(tanggal) AS totRits
   FROM tblsolar 
   WHERE tanggal LIKE '%sqlDate%' 
   AND supir LIKE '%cboSupir%' 
   GROUP By tanggal) AS totRits,
COUNT(*) AS tNote
FROM tblsolar


totRits
tNote


2
5

tanggal	supir
sqlDate	cboSupir
test	test
test	cboSupir
test	cboSupir
sqlDate	cboSupir