Create a view named Refill_Due. It should consist of the patient id, dateofvisit, rxid, and the dosage for every medicine prescribed that requires refilling. Prefix the columns in the view with “RD”....

Create a view named Refill_Due. It should consist of the patient id, dateofvisit, rxid, and the dosage for every medicine prescribed that requires refilling. Prefix the columns in the view with “RD”. For example, the PATIENTID in the table becomes RD_PATIENTID in the view. Use select statement to display the records from the view just created. See the output below and match your results to the sample output.