Answered step by step
Verified Expert Solution
Link Copied!

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

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

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions

Question

1.what is the significance of Taxonomy ?

Answered: 1 week ago

Question

What are the advantages and disadvantages of leasing ?

Answered: 1 week ago

Question

Name is needed for identifying organisms ?

Answered: 1 week ago

Question

=+Understand the fi eld of comparative IHRM.

Answered: 1 week ago