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?

2016

---

What are the types of feedback oscillators?

821

---

How do you keep the fi posting period open only for certain gl codes?

610

---

What do you understand by mysql terminal?

520

---

How do I delete only certain cells in excel?

301

---

---

What's xlink?

524

---

What is Polymorphism, overloading, overriding and virtual?

589

---

How pm module is integrated with qm module?

484

---

How to check feasibility of the appliction?in automation testing?

1474

---

When will you use workflow?

318

---

How successful is the Swachh Bharat Abhiyaan in country?

617

---

Under what conditions is an object’s finalize() method invoked by the garbage collector?

577

---

Which is best book for data structures in c?

599

---

How to add helper plug-ins on the webpage using html?

475

---

What is report snapshot?

99

---