Question: Use the following database tables to answer questions la, b, c, d, and e. PATIENT Pat.IR Name Home City Pharmr. Ing. ID 20001 OJ Simpson
Use the following database tables to answer questions la, b, c, d, and e. PATIENT Pat.IR Name Home City Pharmr. Ing. ID 20001 OJ Simpson New York, NY A22 NY11 20744 Marcia Clark Aurora, CO C99 B046 20735 Chris Darden San Gabriel, CA C99 AT94 20607 Robert Shapiro Miami Beach, FL A22 NY11 20120 F. Lee Bailey Palestine, TX B33 B046 90210 AC Collins Santa Barbara, CA C99 AT94 MEDICATION Med ID Med Name 005 Tylenol3 010 Ambien 015 Lipitor 020 Prilosec 025 Adderall Ins. ID NYIT AT94 BO46 B046 NY11 PharmID A22 B33 C99 PHARMACY Pharmacy Curbside CVS Y Walgreens N Target Y PRESCRIPTION_ACCOUNT INSURANCE Ins. ID Insurance Name BO46 Obamacare NY11 NY Life CG01 Cigna AT94 Aetna Prescil Pres241 Pres341 Pres441 Pres541 Pres641 Pres 741 Pat ID 20744 20607 90210 90210 20001 20735 Med ID 015 010 025 020 010 005 Pharm ID Total B33 $54.00 A22 $12.00 C99 $78.00 C99 $42.00 B33 $99.00 B33 $4.99 d. List the PHARMACY, MEDICATION, and INSURANCE information for F. Lee Bailey. e. Look at the total spending for all prescriptions, which pharmacy has the highest total for customer spending? List the pharmacy and total amount spent. Use the following database tables to answer questions la, b, c, d, and e. PATIENT Pat.IR Name Home City Pharmr. Ing. ID 20001 OJ Simpson New York, NY A22 NY11 20744 Marcia Clark Aurora, CO C99 B046 20735 Chris Darden San Gabriel, CA C99 AT94 20607 Robert Shapiro Miami Beach, FL A22 NY11 20120 F. Lee Bailey Palestine, TX B33 B046 90210 AC Collins Santa Barbara, CA C99 AT94 MEDICATION Med ID Med Name 005 Tylenol3 010 Ambien 015 Lipitor 020 Prilosec 025 Adderall Ins. ID NYIT AT94 BO46 B046 NY11 PharmID A22 B33 C99 PHARMACY Pharmacy Curbside CVS Y Walgreens N Target Y PRESCRIPTION_ACCOUNT INSURANCE Ins. ID Insurance Name BO46 Obamacare NY11 NY Life CG01 Cigna AT94 Aetna Prescil Pres241 Pres341 Pres441 Pres541 Pres641 Pres 741 Pat ID 20744 20607 90210 90210 20001 20735 Med ID 015 010 025 020 010 005 Pharm ID Total B33 $54.00 A22 $12.00 C99 $78.00 C99 $42.00 B33 $99.00 B33 $4.99 d. List the PHARMACY, MEDICATION, and INSURANCE information for F. Lee Bailey. e. Look at the total spending for all prescriptions, which pharmacy has the highest total for customer spending? List the pharmacy and total amount spent
