Answered step by step
Verified Expert Solution
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 and start with
List out employees who are working in department and draw salaries more than
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 ascendingorder.
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
How many employees joined each month in
How many employees joined in March
Which is the Department ID having greater than or equal to employees joining in April
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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