create table ClientDetails$($

ClientID varchar$(10),$

ClientName varchar$(100),$

ClientEmail varchar$(100),$

ClientDOB varchar$(100),$

PRIMARY KEY $($ClientID$)$

$)$;

create table Staffs$($

StaffID varchar$(10),$

StaffName varchar$(100),$

StaffType varchar$(100),$

PRIMARY KEY $($StaffID$)$

$)$;

create table WorkshopDetails$($

WorkshopID varchar$(10),$

WorkshopName varchar$(100),$

WorkshopType varchar$(100),$

WorkshopDifficulty varchar$(100),$

WorkshopPoint INT,

PRIMARY KEY $($WorkshopID$)$

$)$;

create table WorkshopConducted$($

WorkshopSessionID varchar$(10),$

WorkshopID varchar$(10),$

WorkshopDate date,

StaffID varchar$(10),$

ClientSignedUp int,

ClientAttended int,

WorkshopAttendance decimal$(6,3),$

PRIMARY KEY $($WorkshopSessionID$),$

index $($WorkshopID$),$

index $($StaffID$),$

CONSTRAINT WorkshopID$\_1$ FOREIGN KEY $($WorkshopID$)$ REFERENCES WorkshopDetails$($WorkshopID$),$

CONSTRAINT StaffID$\_1$ FOREIGN KEY $($StaffID$)$ REFERENCES Staffs$($StaffID$)$

$)$;

create table WorkshopAttendee$($

WorkshopSessionID varchar$(10),$

ClientID varchar$(10),$

index $($WorkshopSessionID$),$

index $($ClientID$),$

CONSTRAINT ClientID$\_7$ FOREIGN KEY $($ClientID$)$ REFERENCES ClientDetails$($ClientID$),$

CONSTRAINT WorkshopSessionID$\_1$ FOREIGN KEY $($WorkshopSessionID$)$ REFERENCES WorkshopConducted$($WorkshopSessionID$)$

$)$;create table Brands$($

BrandID varchar$(10),$

BrandName varchar$(100),$

PRIMARY KEY $($BrandID$)$

$)$;

create table ClientBrands$($

ClientID varchar$(10),$

BrandID varchar$(10),$

index $($ClientID$),$

index $($BrandID$),$

CONSTRAINT ClientID$\_8$ FOREIGN KEY $($ClientID$)$ REFERENCES ClientDetails$($ClientID$),$

CONSTRAINT BrandID$\_1$ FOREIGN KEY $($BrandID$)$ REFERENCES Brands$($BrandID$)$

$)$; using these tables $,$Generate a report showing the total number of clients registered for each cooking workshop, categorized by the "Difficulty Level" and brand $("$Gourmet Gurus," "Master Chef Club," or "All"$).$