Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table websites (
  website_Id int not null
  , website_name varchar(32) not null
)

CREATE TABLE


create table fixtures (
  fixture_Id int not null
  , website_Id int not null
  , fixture_details varchar(32) not null
  , date_of_entry date not null
)

CREATE TABLE


insert into websites (website_Id, website_name)
values (1,	'website_a')
,      (2,	'website_b')
,      (3,	'website_c')
,      (4,	'website_d')
,      (5,	'website_e')

INSERT 0 5


insert into fixtures (fixture_Id, website_id, fixture_details, date_of_entry)
values (1,	1,	'a vs b', '2023-01-16')
,      (2,	1,	'c vs d', '2023-01-16')
,      (3,	2,	'e vs f', '2023-01-16')
,      (4,	2,	'g vs h', '2023-01-16')
,      (5,	4,	'i vs j', '2023-01-16')

INSERT 0 5


Select ws.website_id
  , ws.website_name
  , Count (fx.website_id) as TotalRows
FROM websites ws
LEFT OUTER JOIN fixtures fx 
  on fx.website_id = ws.website_id
  and fx.date_of_entry = '16-01-2023'
GROUP BY ws.website_id, ws.website_name


website_id
website_name
totalrows


2
website_b
2

5
website_e
0

1
website_a
2

3
website_c
0

4
website_d
1



SELECT 5