Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following two relations, write sql queries for the following. Employee ( EmployeeID , FirstName, LastName, DepartmentID, and Salary ) Department ( DepartmentID ,

Consider the following two relations, write sql queries for the following.
Employee(EmployeeID, FirstName, LastName, DepartmentID, and Salary)
Department(DepartmentID, DepartmentName)
1) Write an insert query to insert the following employee - John Brown with an employee id of S101 and salary of $80,000
2) Retrieve the FirstName, LastName, and Salary of employees who work in the 'Sales'(DepartmentName) and have a salary greater than $50,000
3) Retrieve the FirstName, LastName, and Salary of employees who have a salary greater than the average salary of all employees.

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

Step: 3

blur-text-image

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

Databases On The Web Designing And Programming For Network Access

Authors: Patricia Ju

1st Edition

1558515100, 978-1558515109

More Books

Students also viewed these Databases questions