852 Which of the following can be used to return the maximum salary (SALARY) for each location (LOC) Select one: O emp %>% group_by(LOC) %>% summarise(max_sal=max(emp$SALARY, na.rm = T)) O emp %>% filiter(LOC="Penang") %>% group_by(LOC) %>% summarise(max_sal=max(SALARY, na.rm = T)) O emp %>% group_by(LOC) %>% summarise(max_sal=max(SALARY, na.rm = T)) O emp %>% group_by(SALARY) %>% summarise(max_sal=max(LOC, na.rm = T))

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
ed1 x
emp x
A 7 Filter
EMPNO
ENAME
DNAME
JOB
HIREDATE
LOC
SALARY
8876
adams
research
clerk
2017-07-23
Johor
5000
8499
allen
sales
salesman 2018-01-23
KL
3400
8698
blake
sales
manager 2016-03-11
KL
10000
8782
ali
accounting
manager 2015-06-25
Penang
11000
8902
ford
research
analyst
2016-02-03
Johor
8700
8900
james
sales
clerk
2017-12-13
KL
3500
8566
jones
research
manager 2015-04-02
Johor
9000
8839
king
accounting
president 2019-11-17
Penang
NA
8654
martin
sales
salesman 2012-06-17
KL
3250
8934
miller
accounting
clerk
2012-01-23
Penang
3000
8788
scott
research
analyst
2017-04-19
Johor
7500
8369
smith
research
clerk
2016-12-17
Johor
5600
8844
turner
sales
salesman 2018-09-08
KL
3000
8521
andrew
sales
salesman 2018-02-22
KL
3200
Which of the following can be used to return the maximum salary (SALARY) for each location (LOC)
Select one:
O emp %>% group_by(LOC) %>% summarise(max_sal=max(emp$SALARY, na.m = T))
O emp %>% fiter(LOC="Penang') %>% group_by(LOC) %>% summarise(max_sal=max(SALARY, na.rm = T))
O emp %>% group_by(LOC) %>% summarise(max_sal=max(SALARY, na.rm = T))
O emp %>% group_by(SALARY) %>% summarise(max_sal=max(LOC, na.rm = T))
Transcribed Image Text:ed1 x emp x A 7 Filter EMPNO ENAME DNAME JOB HIREDATE LOC SALARY 8876 adams research clerk 2017-07-23 Johor 5000 8499 allen sales salesman 2018-01-23 KL 3400 8698 blake sales manager 2016-03-11 KL 10000 8782 ali accounting manager 2015-06-25 Penang 11000 8902 ford research analyst 2016-02-03 Johor 8700 8900 james sales clerk 2017-12-13 KL 3500 8566 jones research manager 2015-04-02 Johor 9000 8839 king accounting president 2019-11-17 Penang NA 8654 martin sales salesman 2012-06-17 KL 3250 8934 miller accounting clerk 2012-01-23 Penang 3000 8788 scott research analyst 2017-04-19 Johor 7500 8369 smith research clerk 2016-12-17 Johor 5600 8844 turner sales salesman 2018-09-08 KL 3000 8521 andrew sales salesman 2018-02-22 KL 3200 Which of the following can be used to return the maximum salary (SALARY) for each location (LOC) Select one: O emp %>% group_by(LOC) %>% summarise(max_sal=max(emp$SALARY, na.m = T)) O emp %>% fiter(LOC="Penang') %>% group_by(LOC) %>% summarise(max_sal=max(SALARY, na.rm = T)) O emp %>% group_by(LOC) %>% summarise(max_sal=max(SALARY, na.rm = T)) O emp %>% group_by(SALARY) %>% summarise(max_sal=max(LOC, na.rm = T))
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Payback period
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education