Write a query that displays the sum of the charges

Assignment Help PL-SQL Programming

Reference no: EM133109038

The purpose of this opportunity is to give you a chance to write an SQL query which will subsequently be used in PL/SQL Opportunity No. 5. The query needs to make use of the following three tables.

SQL> desc doctor
Name Null? Type
----------------------------------------- -------- ----------------------------
DOC_ID NOT NULL NUMBER
DOC_NAME VARCHAR2(20)
AREA VARCHAR2(20)

SQL> desc patient
Name Null? Type
----------------------------------------- -------- ----------------------------
PT_ID NOT NULL NUMBER
PT_LNAME VARCHAR2(15)
PT_FNAME VARCHAR2(15)
DOC_ID NUMBER

SQL> desc billing
Name Null? Type
----------------------------------------- -------- ----------------------------
PT_ID NOT NULL NUMBER
BALANCE NUMBER
DUEDATE DATE
PT_INS VARCHAR2(25)

The content of the three tables can be created by executing the S22-doctorsdatabase.sql script file The content of the tables associated with this file appear on the next page.

The task for PL/SQL Opportunity No. 4 is to write a query that displays the sum of the charges for each of the doctors. Using the data on the next page, you should be able to determine if the result generated by your query is correct. If your knowledge of SQL allows you to write this query without a hint from me, then I will award you 12 points.

Before writing a query, I suggest that you begin by defining the problem and manually computing the sum of the charges for one of the doctors. Doctor ID 509 might be a good choice.

You are going to need to join the DOCTOR, PATIENT, and BILLING tables together and then group the results of the join by doctor in order to determine the total number of charges and the sum of the charges for each doctor.

Attachment:- PL SQL Opportunity.rar

Reference no: EM133109038

Questions Cloud

Distinction between globalism and globalization : Describe and explain a clear distinction between "globalism" and "globalization" after viewing the video and reading the article.

Session taste positive for substance : 1. How can one deal with the situation where a client is on probation and on his final session taste positive for substance use how would your response as a cli

Calculate how much money Fred will have : Johnny started investing $1,500 per year in an account earning 4% interest compounded annually. Calculate how much money Fred will have

Explain the decision-making model : 1. How can one deal with the situation where a client on withdrawal gets sick, falls, and destroys your property? How would your response as a clinician be in m

Write a query that displays the sum of the charges : Write an SQL query which will subsequently be used in PL/SQL Opportunity No. 5 - The content of the tables associated with this file appear on the next page

Prepare journal entries to record transactions of Kiterup : Prepare journal entries to record the transactions of the Kiterup Winter Sports Association for the year ended December 31, 2020

Expensive way to measure employee performance : Why do we consider the 360-Degree appraisal as the most comprehensive and expensive way to measure employee performance?

What should be the company before tax cost of debt : XYZ industries issues bond to finance its new project for which it offers 10 years, 5% semi-annual coupon bond. What should be the company before tax cost

Position description-specification for hris administrator : One way to assess the nature and importance of a particular function or position in an organization is to examine the job description and job specifications for

User Account

All Pages