SQL Assignment06 - Group By or Having Clause

1. List the branches having sum of deposit more than 5000.
2. List the branches having a sum of deposit more than 5000 and located in city BOMBAY.
3. List the name of Customers having deposit in the branches where the average deposit is more than 5000.
4. List the names of customers having maximum deposit.
5. List the names of customers having maximum deposit in the table CUSTOMERS living in Nagpur.
6. List the name of branch having highest number of depositors.
7. Count the number of depositors living in Nagpur.

SQL Best Practices - Part1

Never put SQL scalar functions on columns in the WHERE predicates.
For example: WHERE YEAR(HIREDATE) = 2009 should be recoded as WHERE HIREDATE BETWEEN '2009-01-01'and '2009-12-31'.
When placing SQL scalar functions on columns in the SELECT portion of the SQL statement does incur some minimal overhead, but applying it to a column in the WHERE clause causes the predicate to become stage to non indexable.

Same applies for mathematics.
For example: WHERE HIREDATE – 7 DAYS > :HV-DATE should be recoded as WHERE HIREDATE > :HV_DATE + 7 days. Having the mathematics on the host variable is not a problem.

Create Users and Groups for IBM Information Server[DataStage]

To create users and groups for IBM Information Server:

1.      On the computer where you installed the clients, log in to the Web console, which is on the computer where the domain is installed.

o        Windows: Click Start > IBM Information Server > IBM Information Server Web Console and log in to the console with your suite administrator credentials.

o        Linux or UNIX: Open Microsoft Internet Explorer on a Windows computer and go to the URL of the Web console. Log in to the Web console with your suite administrator credentials. The URL takes the form http://host_server:port. host_server is the name or IP address of the computer where the domain is installed. port is the port number for the Web console. The default port number is 9080.