Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If i have the table1 below. Name cash id phone name1 28 x 111 111 name1 24 x 111 111 name2 24 z 222 222
If i have the table1 below.
Name | cash | id | phone |
name1 | 28 | x | 111 111 |
name1 | 24 | x | 111 111 |
name2 | 24 | z | 222 222 |
name3 | 22 | q | 333 333 |
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, and total cash
In this table it would be tie name1 and name4
- 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