Question
$5.00 sql programming
- From Computer-Science: General-CS
- Closed, but you can still post tutorials
- Due on Mar. 22, 2010
- Asked on Mar 21, 2010 at 5:42:13PM
$10.00
Full tested sql queries with explanations of some specific details
- This tutorial was purchased 2 times and rated A+ by students like you.
- Posted on Mar 21, 2010 at 10:54:05PM
A:
Preview: ... ps you to understand how everything is used.
Write a query to display the current date. Label the column Date. SELECT DISTINCT current_date "Date" from EMP; Display the employee number, name, salary, and the salary increased by 15% expressed as a whole number. Label this new column New Salary. SELECT EMPNO, ENAME, SAL, SAL * 1.15 AS "New Salary" FROM EMP;
Modify the previous query to add a column that will subtract the old salary from the new salary. Label the column Increase.
SELECT EMPNO, ENAME, SAL, SAL * 1.15 AS "New Salary", (SAL * 1.15) - SAL AS "Increase" FROM EMP Display the em ...
The full tutorial is about 491 words long plus attachments.
$5.00
sql script
- This tutorial was purchased 1 time and rated No Rating by students like you.
- Posted on Mar 22, 2010 at 12:12:31PM
A:
Preview: ... 2. Display the employee number, name, salary, and the salary increased by 15% expressed as a whole number. Label this new column New Salary. select empno, ename, sal, round((sal*1.15)) as new_salary from emp; 3. Modify the previous query to add a column that will subtract the old salary from the new salary. Label the column Increase. select empno, ename, sal, round((sal*1.15)) as new_salary, (round((sal*1.15)) - sal) as increase from emp; (a) Display the employee's name, hire date, and salary review date, which is the first Monday after six months of service. Label the column REVIEW. ...
The full tutorial is about 428 words long plus attachments.