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?
No Answer is Posted For this Question
Be the First to Post Answer
Explain “@@rowcount” and “@@error” in sql server?
How to convert a unicode strings to non-unicode strings?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is #temp and @table variable in SQL server?
what is the cursor life span?
Is Sql non procedural query language?
How to use user defined functions in expressions?
What is difference between oltp and olap?
How to get a list all databases on the sql server?
What is Check point? Explain in Brief what it will do?
explain different types of cursors? : Sql server database administration
What is ddl and dml commands?