Answered step by step
Verified Expert Solution
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?
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.7Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started