Find customer with the maximal time gap in days

Assignment Help Other Subject

Reference no: EM133882572

Problem

Find the name of employee who opened the account that has the most total amount of dollars of transactions

I. List all employees whose last name matches the following: last name should not start with b or g, the 2nd character of the last name should be i, and the second to last character should be e

II. List all employees and his/her supervisor pairs, the join date of employee is earlier than that of his/her supervisor

III. Gorup employees based on the 1st character of their last na,e into 2 sets (a-r) and (s-z) show the number of open accounts associated with each set. Get the instant assignment help.

IV. We segment individual customers into groups based on the tes digit of their age (30s, 40s, 50s, 60s, 70s, 80s, ...) write a sql query to show how many individual customers in each group

V. The employment period of an employee can be calculated using the date diff () function on her/his start date and the current date. Show in which department the employee has the highest average employment period

VI. Amoung all customers who have more than one account, find customer with the maximal time gap in days between his/her accounts open dates.

Reference no: EM133882572

Questions Cloud

Major features of physical-cognitive and social development : Define adolescence and describe the major features of physical, cognitive, and social development that take place during adolescence.

Elicit range of emotional responses : Often a person describes an abnormal behavior as weird-a term that can elicit a range of emotional responses

Describe the professional relevance of this topic : Summarize the health care problem or issue. Describe the professional relevance of this topic. Describe any professional experience you have with this topic.

Understanding of consequences of child maltreatment : How does this information enhance your understanding of the consequences of child maltreatment?

Find customer with the maximal time gap in days : Amoung all customers who have more than one account, find customer with the maximal time gap in days between his/her accounts open dates.

Genetic factors that contribute to epidemic : What are the genetic factors that contribute to this epidemic? How does social media use contribute to the stigma of obesity?

What is the difference between npv and irr : HCS 385- What is the difference between NPV and IRR? Reflect on whether work you completed in this worksheet was useful to you or not. Explain why or why not.

Mental health treatment facility to support treatment : How might psychological testing be used in mental health treatment facility to support treatment? What tests might be included in psychological evaluation?

Calculate the price elasticity of demand using the midpoint : HM5003 Economics for Business, Holmes Institute - Present a company strategy to your Management Board and to the Federal Government of Australia covering

User Account

All Pages