ind the names of all employees who earn more than every employee of Small Bank Corporation. 8. Display the average salary of each company except Square Pharma. 9. Find the company with the most employees. 10. Find those companies whose employees earn a higher salary, on average, than the ave salary of Small Bank Cornoration

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
7. Find the names of all employees who earn more than every employee of Small Bank
Corporation.
8. Display the average salary of each company except Square Pharma.
9. Find the company with the most employees.
10. Find those companies whose employees earn a higher salary, on average, than the average
salary of Small Bank Corporation.
Transcribed Image Text:7. Find the names of all employees who earn more than every employee of Small Bank Corporation. 8. Display the average salary of each company except Square Pharma. 9. Find the company with the most employees. 10. Find those companies whose employees earn a higher salary, on average, than the average salary of Small Bank Corporation.
Sample Data
Table Name
Data
employee
city
Bogra
Comilla
ename
street
Barkat
Jabbar
Jubayer
Najmun Nahar
Oronno
Faridpur
Sylhet
Dhaka
y
Rafique
Rahim
Rajshahi
Dhaka
Sabbir
Chittagong
Comilla
Salam
Sharafat
Dhaka
works
salary
jdate
спаme
First Bank Corporation
First Bank Corporation
First Bank Corporation
Small Bank Corporation
First Bank Corporation
Small Bank Corporation
Najmun Nahar Small Bank Corporation
The ONE Limited
ename
Rahim
50000 2008-01-01
Barkat
Salam
40000 2007-01-01
60000 2009-07-01
Rafique
Sharafat
30000 2009-06-0S
s0000 2005-06-01
Jabbar
10000 2009-06-05
20000 2009-06-30
Oronno
50000 2007-06-01
Jubayer
Sabbir
Square Pharma
Vegabond Company
15000 2008-01-01
100000 2001-01-01
соmpany
city
Chittagong
Chittagong
cname
Anonymous IT
Dream Tech
First Bank Corporation
JONS IT (Pvt.) Limited
Small Bank Corporation Dhaka
Square Pharma
The ONE Limited
Unique Softs
Unknown Systems
Vegabond Company
Dhaka
Sylhet
Bogra
Dhaka
Dhaka
Rajshahi
Bogra
manages
ename
mname
Rahim
Barkat
Salam
Sharafat
Sharafat
Sharafat
Rafique
Jabbar
Najmun Nahar
Jubayer
Oronno
Oronno
Sabbir
Sabbir
Transcribed Image Text:Sample Data Table Name Data employee city Bogra Comilla ename street Barkat Jabbar Jubayer Najmun Nahar Oronno Faridpur Sylhet Dhaka y Rafique Rahim Rajshahi Dhaka Sabbir Chittagong Comilla Salam Sharafat Dhaka works salary jdate спаme First Bank Corporation First Bank Corporation First Bank Corporation Small Bank Corporation First Bank Corporation Small Bank Corporation Najmun Nahar Small Bank Corporation The ONE Limited ename Rahim 50000 2008-01-01 Barkat Salam 40000 2007-01-01 60000 2009-07-01 Rafique Sharafat 30000 2009-06-0S s0000 2005-06-01 Jabbar 10000 2009-06-05 20000 2009-06-30 Oronno 50000 2007-06-01 Jubayer Sabbir Square Pharma Vegabond Company 15000 2008-01-01 100000 2001-01-01 соmpany city Chittagong Chittagong cname Anonymous IT Dream Tech First Bank Corporation JONS IT (Pvt.) Limited Small Bank Corporation Dhaka Square Pharma The ONE Limited Unique Softs Unknown Systems Vegabond Company Dhaka Sylhet Bogra Dhaka Dhaka Rajshahi Bogra manages ename mname Rahim Barkat Salam Sharafat Sharafat Sharafat Rafique Jabbar Najmun Nahar Jubayer Oronno Oronno Sabbir Sabbir
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY