Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 The following four problems are based on company database 2. R than 10 hours etrieve the names of employees in department per week on the Productx project. who work more 3. Find the names of employees that are directly supervised by Franklin Wong 4. Retrieve the first and last names of employees and the first names of their dependents. Regardless of if they have any dependents, each employee should be present in the output. 5. Retrieve the SSN's of employees that worked on all the projects Alicia Zelaya worked on. 6. (Extra credit: 4 pts) From imdb full database in ist274csusb, find the actors that acted in ALL the movies Lou Fillipo was in. Submit query and screenshot
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started