Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If i have the table1 below. Name cash idintifer phone Name3 22 q 333 333 Name1 24 x 111 111 Name1 28 x 111 111
If i have the table1 below.
Name | cash | idintifer | phone |
Name3 | 22 | q | 333 333 |
Name1 | 24 | x | 111 111 |
Name1 | 28 | x | 111 111 |
Name2 | 24 | z | 222 222 |
Name4 | 52 | a | 444 444 |
What is an sqllive query i can use to get the below
- the person who has the most cash (MAX of SUMs)
- result should show the name, ID and phone
- if two ppl tie (have same amount of cash) both names should show.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started