Question: Solve it please / Database 17. From Emp table, write a query to find the employees in the ascending order of their annual salary. Return

Solve it please / Database

17. From Emp table, write a query to find the employees in the ascending order of their annual salary. Return employee no, employee name, salary, salary/30 as Daily_Salary, and 12 salary as Anual_Salary. 18. From Emp table, write a query to list the employees in the ascending order on job name and descending order on employee no. Return complete information about the employees. 19. From Emp table, write a query to list the unique jobs of department 20 and 30 in descending order. Return job name

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using the database(SQL), write the queries for all the following questions. More information is provided at the end. From the Emp table, write a query to find those employees whose commission is more...

Using the database(SQL), write the queries for all the following questions. More information is provided at the end EMPNO ENAME JOB MGR HIREDATE SALCOMM DEPTNO 1 7369 SMITH CLERK 7902 17/12/80 800...

Go to "Try it yourself" section of w3schools link. Create two tables in that database - Employee and Department. You can keep required basic columns in both tables. Relationship between Department to...

***********PLEASE USE THIS TABLES SQL************ DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE SALGRADE; create table dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept...

please consider the above image. This problem involves a Information Technology course, Information System Design and the current topic invlovling this problem is constucting SQL database . Please...

Create HR database with the following tables. Write SQL query for the following questions based on above database. No. Question 1. Write a SQL query to find those employees whose salaries are less...

Task 18 (100 points. Given the structure of the ConstructCo database shown above, use SQL commands to answer the problems in the following steps. 1. Write the SQL code required to list the employee...

Write SQL queries to answer the following questions: Write a query to list the employees first, and last name as well as their hire date and commission _ pct . If the commission _ pct is empty report...

Write a query to display the employees name and hire date for all employees in the same department as 'Blake'. Exclude 'Blake'. Create a query to display the employee number and name for all...

This task has five parts. IMPORTANT: If you do not complete this step, your work will not be graded at all. You will get a zero for the project. Create a company database named as COMP _ your first...

A recently certified accountant tells you that they have a prospective new client. The client is well-respected in the community and taking on the client could prove to be a significant boost for...

Per capita production is 2.0 / 1 + bt/1000. Sketch f(bt) for 0 bt 2000. In a discrete-time dynamical system describing the growth of a population in the absence of immigration and emigration, the...

16. The perimeter of a rectangular campsite is 64 m and its area is 207 m. Find the length and the breadth of the campsite.

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

Message Strategies: Responding to Rumors and Public Criticism [LO-7] The consumer reviews on Yelp can be a promotional boon to any local businessprovided the reviews are positive, of course. Negative...

Message Strategies: Responding to Rumors [LO-7] Sheila Elliot, a well-known actress, appeared on a national talk show last night and claimed your companys Smoothstone cookware was responsible for her...

I want to make one thing perfectly clear neither of you will be promoted if sales figures dont improve. Review Sections 2.4, 2.5, and 2.6 in the Handbook of Grammar, Mechanics, and Usage, and then...