Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List out the employees whose name starts with ' S ' and ends with ' H ' . List out the employees whose name length

List out the employees whose name starts with 'S' and ends with 'H'.
List out the employees whose name length is 4 and start with 'S'.
List out employees who are working in department 10 and draw salaries more than 3500.
List out the employees who are not receiving commission.
ORDER BY Clause:
List out the Employee ID and Last Name in ascending order based on the Employee ID.
List out the Employee ID and Name in descending order based on salary.
List out the employee details according to their Last Name in ascending-order.
List out the employee details according to their Last Name in ascending order and then Department ID in descending order.
GROUP BY and HAVING Clause:
How many employees are in different departments in the organization?
List out the department wise maximum salary, minimum salary and average salary of the employees.
List out the job wise maximum salary, minimum salary and average salary of the employees.
List out the number of employees who joined each month in ascendingorder.
List out the number of employees for each month and year in ascending order based on the year and month.
List out the Department ID having at least four employees.
How many employees joined in the month of January?
How many employees joined in the month of January or September?
How many employees joined in 1985?
How many employees joined each month in 1985?
How many employees joined in March 1985?
Which is the Department ID having greater than or equal to 3 employees joining in April 1985?
image text in transcribed

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

Students also viewed these General Management questions

Question

Nuclear sizes are expressed in a unit named?

Answered: 1 week ago