Display the employee name, salary of all employees who have a title of Sales Rep
ID: 3574473 • Letter: D
Question
Display the employee name, salary of all employees who have a title of Sales Representative. Display the employees name and hire date for employees hired in 1993. Display the name, salary, department name of employees working in the Sales department. For all products display the product name, category id and category name. Sort the output by product name Display the product name, cost and unit price where the units in stock is less than the units on hand. List the product id and product name of all products that have been discontinued. Sort the list by product name. List the company name of all customers that have a last name that begins with a "S".Explanation / Answer
1)SELECT emp_name,salary from EMPLOYEES where title='SalesRepresentative';
2)SELECT emp_name,hire_date from EMPLOYEES where hire_date LIKE '%93';
3)SELECT e.emp_name,d.salary,d.dept_name from EMPLOYEE e,DEPTARTMENT d where d.dept_name='sales' and e.emp_id=d.emp_id;
4)SELECT product_name,category_id,category_name from PRODUCTS ORDER BY product_name;
5)SELECT procut_name,product_cost,product_price WHERE units_in_stock<units_on_hand;
6.)SELECT product_id,product_name from PRODUCTS order by product_name WHERE list_price<real_price;
7)select company_name from CUSTOMERS where last_name LIKE 'S%';