Create a view named PoorPat that contains every patient who has prescribed the most drug. The view contains patno and name (patient name) and tally (the number of drug prescriptions).

Given the following 7 relations:

Patient (patno, name, add, ssno, driverno)

Staff (staffno, name, add, ssno driverno)

Doctor (docno, name, add, ssno, driverno)

Admission (roomno, patno, startdate, enddate, staffno)

Room (roomno, type, fee)

Drug (drugno, drugname, drugsalesprice, drugprice)

Prescription (prescno, docno, patno, drugno, stardate, enddate)