Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. retrieve the ssn and salary of the employee who wo

Retrieve the SSN and salary of the employee who work for the headquarter department. 2. List all...

50.1K

Verified Solution

Question

Programming

  1. Retrieve the SSN and salary of the employee who work for theheadquarter department.

2. List all the departments name , the manager’s name of eachdepartment and the location of each department.

  1. List the last name of each employee whose salary is more than30,000 and the last name of his/her supervisor

Answer & Explanation Solved by verified expert
4.0 Ratings (654 Votes)
Since your question does not have table structure I am adding this table str and trying to resolve your question If you have different table str write your query according else post that table str also Thanks in advance create table dept    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

2 What about the next shape in this pattern Write a conjecture that des

Geometry
Q

Discuss a technical problem you have experienced with a device, equipment or vehicle in form of...

Mechanical Engineering
Q

Problem 12-4A Partnership income allocation, statement of partners' equity, and closing entries LO P2 [The following information...

Accounting
Q

9 Determine the factors of 5x 23x 42 a 5x 7 x 6 b x...

Basic Math
Q

The equation x-6x + y +6y+9=0 is an equation of a circle in expanded form....

Basic Math
Q

Here are the data on the age of students that attend Norco College Age 19...

Statistics
Q

Find the inverse function of f informally Verify that f f 1 x x and...

Calculus
Q

graph y 1 2x 1

Algebra
Q

9-Dec Issued check to U. Sleepy in payment of $4,000 owed, less a 1% discount....

Accounting
Q

please answer this quick A company's total ovcrhead rate of...

Accounting
Q

Which 3 of these statements are true about using QuickBooks online to determine profitability within...

Accounting
Q

What is the purpose of a trust fund? Trust funds are to held for that...

Accounting