This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2492

What are the Advantages of hosting wcf in iis?

896

During the testing of a module tester, 'x' found a bug and assigned it to a developer. But developer rejects the same, saying that it's not a bug. What 'x' should do?

1252

Explain HCatStorer APIs?

5

What is the application server?

894

What are the different types of frames tags used in html?

783

How to add a new search server?

740

How do I create an index cross reference in word 2016?

601

What does clean url mean?

152

How does a web application works?

819

How do I submit e-application?

1020

functions of a resolver

1996

What is earth observation satellite?

713

What are benefits of linux?

922

who are the stake holders in gathering requirement of a new product

2002