Oracle SQL Exercise 1

--**************** Basic Query ****************--query the last name of all employees-eliminate duplicate surnames-Create a query to display the unique job code in the Employees table-Create a query that displays the last name of each employee, The job code, the hire date, and the employee number, and first displays the employee number. Provide an alias for the hire_date column: startdate--calculates the employee's monthly income (payroll + Commission)-calculates the employee's annual revenue--queries the employee's name--Displays the last names connected to the job ID, separated by commas and spaces, which are named employee and title--creates a query that displays all the data for the Employees table, separating the columns with commas, and naming the rows returned as the_output--**************** qualified ****************-- Query the name of the department (not duplicates) at position 1700--Create a query, Displays the last name and department number of the employee with employee number 176-the last name and salary of the employee who queried for a salary above 10000-the employee who queried for a salary of less than 3000-queries the last name of the employee who entered the service between February 20, 1998 and May 1, 1998, Job identification and start date-Displays the last name and date of employment of each employee employed in 1994--* Query an employee who does not have a commission--query employee whose last name starts with B--query the employee whose department number is 10 or 20 or 30--Query the last name and title of all employees without a manager--displays the last name of all employees whose third letter is "a" in the employee's name--**************** logical operation --Find out what a Commission employee does (no duplicates)--Find out if the employee who does not charge a commission or a commission higher than 100-shows the last name of all employees who have "a" in their last name and "E" in their last name-show their title as a sales representative (Sa_ REP) or the warehouse administrator (St_clerk) and the salary does not equal the last name, title, and salary of all employees of 2500,3500,7000-the last name and salary--**************** of all employees that show that the salary is not in the 5000-1200 range * --Query employee data, sorted by salary in ascending order--Query employee information, Sort by salary in ascending order of the department number from large to small--Displays the last name and department number of all employees in department 20 and department 50 in alphabetical order--Displays the last names, salaries, and commissions for all employees who can earn commissions, and sorts the data in descending order by salary and commission