What are the final balances for each account

Assignment Help Computer Engineering

Reference no: EM133218583

Question 1: How many accounts were originated/created in the year of 2018 (Transaction description is ACCOUNT ORIGINATION)?

Question 2: Which day of 09/2018 was the busiest day in terms of total transaction amount/withdraw amount/deposited amount?

Question 3: Who is the user having the most accounts? (show the userid and user's full name).

Question 4: What is the top 3 most frequent transaction types in 09/2018? Display transaction description, and the number of transactions.

Question 5: What is the total amount of transactions with checks?

Question 6: What are the final balances for each account by the end of 09/2018? And What are the total final balances for all account by the end of 09/2018?

Question 7:Write(SQL) a query to display the user's full name and full address with the accounts.

Question 8:Is there one or more than one accounts that do(es) not have any transactions in 09/2018?

Question 9:Who are the TOP 5 with ties users who use their accounts most frequently? Display userid, user full names, and number of transactions.

Question 10: For each of Top 5 with ties users in Q9, what is the most frequently used transaction type? Display userid, description, and the number of transactions in each transaction type.

Reference no: EM133218583

Questions Cloud

Prepare a public service announcement : Prepare a public service announcement Powerpoint targeting senior citizens and the dangers of phishing and smishing attacks. The video should include the social

What person is failed to meet their responsibilities : Research & Summaries Essay - Identify what person or agency is failed to meet their responsibilities in assuring safety for those who died

Design your own database system for a grocery store : Describe every stage of design, from requirement analysis, business rule generation, big table creation which results in the overall table for 1st NF, and up

Implement the spell checker and the hash table : Implement the spell checker and the hash table, respectively. Create a UML class diagram that describes your class design.

What are the final balances for each account : What are the final balances for each account by the end of 09/2018? And What are the total final balances for all account by the end of 09/2018?

Identify computers that may have been used for the attack : ISSC630 - Advanced Cybercrime Analysis Assignment - Cyber Analysis Essay, American Military University - identify computers that may have been used for attack

Process results from lower layers : Process these results from lower layers and pass the appropriate information to upper layers. Assess the security disadvantage of this layered approach.

What was the cybercrime discussed in the article : What was the cybercrime discussed in the article? What was the impact of this particular cybercrime and Where in the network topology could firewalls

How collaboration can lead to improved patient outcomes : Discuss how collaboration can lead to improved patient outcomes. Explain how multidisciplinary collaboration can affect clinical decision-making

User Account

All Pages