Question: PLEASE DO THE SQL QUERIES, AI GETS THEM WRONG: lIst all the customers ( first and last name ) and their age. ( hint: age

PLEASE DO THE SQL QUERIES, AI GETS THEM WRONG: lIst all the customers (first and last name) and their age. (hint: age=2024 birth year)(1pt)
Show the average annual income by age. Sort the results in ascending order by age. (1pt)
What is the utilization ratio (balance/credit limits) of each credit card (credit card number)? Round the ratio to 1 decimal place. (2pt)
Show the average utilization ratio of each credit card type. (2pt)
List the California customers (first and last name) that have a total card balance of at least $10,000.(2pt)
For each transaction, show the transaction date, transaction amount and the type of credit card used in the transaction. (2pt)
List the credit cards (card number) that have spent more than $20,000 in total in entertainment category. (2pt)
For each credit card type and transaction category, show total transaction amount.
We would like to investigate anomalous transactions of which the amount is more than 95% of the corresponding credit card limit. Show all anomalous transactions. (2pt)
How many anomalous transactions does each card type have? (2pt)
What is the debt-to-income ratio (total balance/annual income) of each customer (first and last name)?(2pt)
 PLEASE DO THE SQL QUERIES, AI GETS THEM WRONG: lIst all

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!