Question: List the unique full name ( first name and last name ) of all authors who have an address with ' St ' anywhere in

List the unique full name (first name and last name) of all authors who have an address with 'St' anywhere in it.

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 Programming Questions!

Q:

Mr. Om was very pleased with the work you did for him last week and wants you to retrieve a few more reports for him. He has also recommended you to work for his friend, Mr. Bok who owns a small...

Q:

Create four Java classes called Name, Address, Employee, and TestEmployee. The TestEmployee class should implement a main method in which an object of Employee is instantiated and its values are...

Q:

Home Formules Data View Page Layout Review Acrobat Arial 12 - An Water WO ST SI AESEMerge Cette 5 - %5 Conditional for Foy- Solin Numb pand rond Alignment D Natalie is the CEO of Sugden Company. She...

Q:

(use python)This program will read multiple basketball players data from a file. The program then calculates some statistical data and display them on the screen. The program requires from you to...

Q:

C++ Program Goal: Your assignment is to write a C++ program to read in a list of appointment records from a file and output them in a more user-friendly format to the standard output (cout),...

Q:

Cis 111 Assignment #2 Chapter 4 Query Problems Query #1: List the company name, contact name, contact title and the phone number for customers who HAVE NOT put in an order. Use an outer join. Query...

Q:

Query #1: List the company name, contact name, contact title and the phone number for customers who HAVE NOT put in an order. Use an outer join. Query #2: Create a listing displaying the employee...

Q:

Cis 111 Assignment #2 Chapter 4 Query Problems Query #1: List the company name, contact name, contact title and the phone number for customers who HAVE NOT put in an order. Use an outer join. Query...

Q:

IN JAVA The Department of Motor Vehicles (DMV) is responsible for issuing drivers licenses. This section of the lab asks you to write a 2 Java classes License and DMV. . The L icense should have the...

Q:

Write a MARIE program to encode your name and ID as a string The following example of a MARIE string "nameID" encodes a name and an ID using ASCII characters. The "name" is separated from the ID by...

Q:

Figueroa Corporation prepared the following variance report. InstructionsFill in the appropriate amounts or letters for the question marks in the report. FIGUEROA CORPORATION Variance...

Q:

Which of the following is not included in the standard (unmodified) report on the financial statements? a. An identification of the financial statements that were audited. b. A general description of...

Q:

12. Neurosis means a chronic emotional disturbance that arises from suppressed or forgotten emotional stress (such as resentment, hostility, aggression, or guilt) experienced in early childhood....

Q:

Vision is to retina, as hearing is to temporal lobe. cochlea. auditory nerve. oval window.