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
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