CREATE TABLE DrugRecords

$($

DrugRecordID INT PRIMARY KEY,

PatientID INT,

DrugName VARCHAR$(255),$

PrescriptionDate DATE,

Dosage VARCHAR$(255),$

PrescribingDoctorID INT

$)$;

INSERT INTO DrugRecords $($DrugRecordID$,$ PatientID, DrugName, PrescriptionDate, Dosage, PrescribingDoctorID$)$

VALUES

$(12958,1258,$ 'Heart Clear', $\text{'}2024-01-01\text{'},\text{'}12\text{'},35),$

$(33333,2258,$ 'Nervous Help', $\text{'}2024-02-01\text{'},\text{'}40\text{'},78),$

$(15555,2245,$ 'Lung Work', $\text{'}2024-03-01\text{'},\text{'}5\text{'},78),$

$(13333,2236,$ 'Lung Guard', $\text{'}2024-01-15\text{'},\text{'}10\text{'},123)$;

select $*$ from DrugRecords

UPDATE STATISTICS DrugRecords; $((($That is the data I have how do I write a script that will show the statistics for the data. PLEASE HELP$)$