Question: ORACLE DATABASE, SQL. Write a query against the LEDGER table shown below to show the names of all person customers with their last name, first

ORACLE DATABASE, SQL.

Write a query against the LEDGER table shown below to show the names of all person customers with their last name, first name. Exclude companies, schools, stores, churches, the post office, brothers and value with a single word(e.g. BLACKSMITH). Your results should look similar to this:

PERSONS ------------------- ARNOLD, MORRIS AUGUST, GEORGE AUSTIN, JOHN

The LEDGER table:

ORACLE DATABASE, SQL. Write a query against the LEDGER table shown below

Columns

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!