Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And SQL

Authors: Lucy Scott

3rd Edition

1087899699, 978-1087899695

More Books

Students also viewed these Databases questions

Question

Why does the balance-of-payments statement balance?

Answered: 1 week ago

Question

List and explain the four steps in the communication process.

Answered: 1 week ago