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 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
Get step-by-step solutions from verified subject matter experts
