Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Identify the attributes in the above table along with a sample tuple Write a SQL query to find all employees whose salaries are greater
Identify the attributes in the above table along with a sample tuple Write a SQL query to find all employees whose salaries are greater than 80 and less than 120 Write a SQL query to delete (remove) the tuple with Dept CS Write a SQL query to find the total number of employees that belong to Dept CS Write a SQL query to find the average of salary of all employees whose rank is faculty ID 10 12 18 43 28 32 25 37 48 50 53 48 58 Employees Last name Dept David EE Carlos CS Edward CS Frank Chem Jones Physics Lopez Physics Ellen Chem James Bio Smith FE Rogers Chem Evans Bio Chem CS Mary Diaz Rank Faculty Post doc Faculty Post doc Faculty Grad St Faculty Post doc Faculty Post Doc Faculty Grad St Grad St Salary 95 50 105 55 82 25 80 40 108 45 88 22 25
Step by Step Solution
There are 3 Steps involved in it
Step: 1
The table provided is named Employees and it includes the following attributes columns 1 ID 2 Last n...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