Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can anyone helps me with this SQL. 1- Write a SQL query to display list of unique first and last names of students, admins and

Can anyone helps me with this SQL.

1- Write a SQL query to display list of unique first and last names of students, admins and instructors.

2-Write a SQL query to display list of employee IDs along with their salary. Also, display max and min. salary currently being paid to the employees.

3.Write SQL query to display records of employees (IDs and Salary) who are earning less than $5000. Also, display total number of employees getting less than $5000

4.Display records of employees (IDs, hire_date, Department ID) who joined company in year 1998. Also, display how many from these belong to Department ID 8.

5.Write a SQL query to display list of unique first and last names of admins, instructors and employees (from Database) . Conditions: a. Instructor's first name must start with 'a' b. Employee's first name must end with 'y' and last name must have at least one occurrence of letter 'a'

6.Write a SQL query to display how many employees were hired in 1987, 1998, 1999 and 2000

7.Write a SQL query to display only year part when employees were hired. Also, display total number of years (when hiring was done) at the end.

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

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284892, 978-3642284892

More Books

Students also viewed these Databases questions