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?

2611

---

Why do all model object attributes get marked with @dynamic and not synthesised?

1006

---

How to make a robo car .Please give me whole theory ,photos of circuits etc. on my e-mail id.

3665

---

Explain how to change the port of the orbix notification service?

861

---

What is java string pool?

1117

---

i am a student of thapar university final year.can anybody please help me with the exam pattern of the companies:engineers india ltd. ; iocl ; UOP, HPCL. If psbl plz send me the previous years questions on this email id k_arora1987@yahoo.com. i d be really greatful

2487

---

What would you like to do - lead or follow?

1270

---

speak an minute where u reside

2546

---

hi friends, dis is ramana reddy.i have been workining in bulk drugs as QC chemist.i would like 2 change d company.i want sample RESUME,OFFER LETTER,APPOINTMENT LETTER,PAY SLIP.if any body has these documents,pls send 2 my mail id i.e ramanareddy.sdpl@ymail.com

2433

---

tell me abt ur most memorable moment

2281

---

Different types of authentication modes in .net framework ?

1095

---

what is new updates in account

2167

---

Explain the types of operations? Draw the figure for shift and rotate operations?

3455

---

can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process

1897

---

please send me rrb question papers of SE MECHANICAL

2272

---