Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following questions should be answered using SQL commands. Who are the employees with a base salary greater or equal to the average of all

The following questions should be answered using SQL commands.

Who are the employees with a base salary greater or equal to the average of all base salaries?image text in transcribed

CSV JSON CSV JSON Rows 393 last_name address state zip_code phone email hire_date department_id commission_... 78112 Morris Ave CT 6473 203-721-3388 2 0.45 Layous Hoopengardner Yaw mlayous ehoopengardner 1997-07-02 1997-07-08 job_title base_salary Marketing Resea... 1600 Automotive Sale... 1400 Treasurer 1600 99352 4 0.89 39 Franklin Ave WA 70295 Pioneer Ct FL 509-755-5393 813-797-4816 33511 ayaw 1997-07-10 5 0.61 Andreason 4 Cowesett Ave NJ 7032 201-920-9002 tandreason 1997-07-19 6 0.44 Berlanga 79 S Howell Ave MI 49546 616-737-3085 vberlanga 1997-08-02 4 Customer Care ... 1100 Wealth Manage... 2700 Account Executi... 1200 0.49 Wide 187 Market St GA 30342 404-505-4445 pwide 1997-09-12 4 0.96 Gotter 4940 Pulaski Par... OR 97202 503-527-5274 1997-10-04 3 CIO 9500 0.51 ngotter Ipaprocki Paprocki 639 Main St AK 99501 907-385-4412 1997-10-10 7 Training Coordin... 3800 0.6 Garufi 69734 E Carrillo... TN 37110 931-313-9635 mgaruhi 1997-10-20 4 Sales Director 6900 0.71 Boulter 8284 Hart St KS 67410 785-347-1805 cboulter 1997-11-09 Customer Care R... 1500 0.06 Steier 93 Redmond Rd FI 32803 407-808-9439 asteier 1997.12.25 6 Customer Relati 2200 0.7

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_2

Step: 3

blur-text-image_3

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

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions