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?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Anyone answer what is average cost for 1 meter GI pipe Hot dipping
How would you describe your own personality
hello sir, could u plz send me a sample placement paper for hpcl trainee engg exam..(electronics stream)...hoping to hear from u at the earliest. Thanking you.
For the 7 stages of the SDLC (Planning, Analysis, Design, Development, Testing, Implementation, and Maintenance), What are the major inputs and outputs of each stage? What are the primary activities in each stage? Who are the primary "players" involved in each stage (e.g., Tech Arch's BA's, Testers etc.)?
What are your views on China's foreign policy and Indo-China relations.
hi this is hema, r there any books in particular for the preparation of the APPSC-A.E.E(electrical), if so please mail me the names ... thank u .
i want to get rrb solved paper of s.e. & j.e.. on my mail mraj.meena@gmail.com
hi i am electronics & telecomm engg & appling 4 the AAI jr executive (electronics/ATC) written test. pls forward me the syllabus & old question papers.I will be very much thankful to you. das.nilanjana2000@gmail.com
1. for eg, capacitor is used for many purposes(it act as filter, oscillator, bypass capacitor, memory storage etc...) 2. Please tell me some example circuits for different uses of capacitor( whenever and whereever and however we used capacitor as a filter, oscillator tuning etc..) 3. similarly for inductor and resistors(it act as what?) and when and how we want to act as like that?, and how we can used these components depends upon our requirments with example circuits and explanation? design to act as these components depends
How to calculate the sag on transmission Lines.
Tell some commonly used Excel VBA functions?
PLESE SEND ME OLD TECHNICAL N APPTITUDE QUESTION PAPERS
IS ANYONE FROM GUJARAT RECEIVED JOINING LETTER OF BOB CLERK 2011 , KINDLY POST IT or CONTACT BY EMAIL. sinhasanjiv73@gmail.com
