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?

2574

can u give me the information about the questions asked by the bally in campus

1966

Hi friends I have experience of 6 months in website design and maintanence. Now i am looking for other IT jobs.. to switch platform. please post any interview you know in chennai.

2283

Would you call yourself a craftsman (craftsperson) and what does that word mean to you?

931

With in the form we want to check all the text box control are typed or not? How?

2081

Is there any possibility in the biztalk FIFO(first-in-first-out) without use the orchestration? how to implement explain?

2217

1.provide a brief write up on why you consider yourself suitable for the post voting your major achievements? 2. Mention your position in the hierarchy and the levels above and below you ?

1770

please send me ubi model papers to my email idsssss anil0001_mca@yahoo.co.in , ravi_kumar3713@yahoo.com thankuuuuuuu

2358

why do u want change u r org

2498

Why can't I see the tabs on my excel spreadsheet?

720

Explain the concept of SHAP and its role in XAI.

145

what is your team size

2520

Explain the approximate cost of the corrosion penetration monitoring system(cpmp)?

1117

sir am giving jspl exam on 19th oct . i belong to eee, so plz send previous question papers ..........to dis id abhilash203@gmail.com

2665

What is the current version of edge?

947