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)

Answer rating: 100% (QA)

To create a view named PoorPat that contains every patient who has prescribed the most drugs you can ... View the full answer