Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Technology And Management Computers And Information Processing Systems For Business

Authors: Robert C. Goldstein

1st Edition

0471887374, 978-0471887379

More Books

Students also viewed these Databases questions