Teradata queries

General

Teradata queries

Ca someone please help me with following queries :-

For the following relation schema: 

 


employee(employee-name, street, city) 

 


works(employee-name, company-name, salary) 

 


company(company-name, city) 

 


manages(employee-name, manager-name)

 


 

 


a) Find the names, street address, and cities of residence for all employees who work for 'First Bank Corporation' and earn more than $10,000.

 


b) Find the names of all employees in the database who live in the same cities as the companies for which they work.

 


c) Find the names of all employees in the database who live in the same cities and on the same streets as do their managers.

 


d) Find the names of all employees in the database who earn more than every employee of 'Small Bank Corporation'

 


e) Assume that the companies may be located in several cities. Find all companies located in every city in which 'Small Bank Corporation' is located.

 

1 REPLY
Senior Apprentice

Re: Teradata queries

Don't you think that the whole purpose of a homework assignment is to solve it on your own and so you advance in your learning process?

 

When you're stuck with a specific question you might show what you tried and ask for help.