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?

2014

---

What is ems sql management studio? : sql server management studio

587

---

how to ctrl motor by use of ac or dc drive.plz explain evdintly

1486

---

What is a pointer how and when is it used?

576

---

What is strongly typed view in mvc?

1

---

---

If we delete the page.tpl.php then drupal site will work or not?

160

---

Explain what is port testing?

615

---

what is the difference between elcb and rccb ?

1780

---

Which are the different factors that affect the reliability of a network?

128

---

What is vc++ programming?

688

---

Explain the process of project tailoring.

586

---

What is the requirement to give RFlow when using RID detector?

2591

---

How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you

605

---

Explain the component of compute in windows azure platform?

344

---

In uipath studio, how elements are recognized on screen?

175

---