Question: The following problem is based on bank database 1. Write a query to reproduce the following output: Display all the customer IDs and types, if

 The following problem is based on bank database 1. Write a

The following problem is based on bank database 1. Write a query to reproduce the following output: Display all the customer IDs and types, if it's an individual, display their full name and birthdate next; if it's a business, display their business name and incorporation date next. cust.id cust type.cd name birth date James Hadley Susan Tingley Frank Tucker John Hayward Charles Frasier John Spencer 1977-04-22 1973-08-15 1963-02-06 1971-12-22 1976-08-25 1967-09-14 Margaret Young 1951-03-19 1982-07-01 1973-06-16 Chilton Engineering 1995-05-01 Northeast Cooling Inc. 2001-01-01 Superior Auto Body 2002-06-30 AAA Insurance Inc. 1999-05-01 George Blake Richard Farley 10 12 13

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!