Question: 1. Create a SQL query in the SQL command window showing the empno, ename, job, sal, and hiredate from emp. Use the TO_CHAR function on

1. Create a SQL query in the SQL command window showing the empno, ename, job, sal, and hiredate from emp. Use the TO_CHAR function on the salary and column aliases where appropriate.

Copy and paste your SQL query along with a screenshot of your result set into your assignment.

2. Create a SQL query in the SQL command window showing the empno, ename, job, sal, and hiredate from the emp table. Use the hiredate column to get all of the employees hired between Jan 1, 1980 and Dec 31, 1981. Use the TO_CHAR function on the salary and column aliases where appropriate.

Copy and paste your SQL query along with a screenshot of your result set into your assignment.

3. Create a SQL query in the SQL command window showing the empno, ename, job, sal, and hiredate from the emp table where salary is between 1000 and 5000. Use the TO_CHAR function on the salary and column aliases where appropriate. Order by ename

Copy and paste your SQL query along with a screenshot of your result set into your assignment.

4. Use the DECODE function on the product information table. Show me the product_name, product_id, category ID, and weight class and list price. If list _price is 1 put Affordable on the report, if list price, is 2 put Medium priced on the report, if list_price is 3 put Expensive on the report, otherwise put Very Expensive on the report for all the other amounts. Select where list_price is greater than 0. Use positional sorting and order by list_price. Use the TO_CHAR function on the list_price.

Copy and paste your SQL query along with a screenshot of your result set into your assignment.

5. Use the CASE statement on the OEHR_ORDERS table. List the order_id, custormer_id, order_mode and order_status. If the order_mode is direct then put Send directly to the main office on the report, if order_mode = online put View online for report else put Other on the report. Order by order_mode and order_id.

Copy and paste your SQL query along with a screenshot of your result set into your assignment.

Submit your problem set 5 assignment to the Problem Set 5 Drop Box

please need an answer asap, thanks

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!

1 . Log in to your Oracle ApEx account. 2. Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate, and the number of years that the employee has worked for the...

PS6 1 . Log in to your Oracle ApEx account. 2. Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate, and the number of years that the employee has worked for the...

Sub-query with an inequality operator. 1. Write a SQL query that uses a sub-query to show the empno, ename, job and total salary for all employees from the emp table that earn more than the average...

1. Write a SQL query that uses a sub-query to show the empno, ename, job and total salary for all employees from the emp table that earn more than the average salary. You will have to times sal by 52...

Populate.sql: Please show with steps on cmd SQL format Rem ******** dropping tables ************* DROP TABLE SALGRADE; DROP TABLE EMPLOYEE; DROP TABLE DEPT; Rem ******** create table DEPT...

SQL statements. 1. Show employees who do not have commission. What commando to use? 2. Show today's date and time in Norwegian format. What commando to use? 3. Show employees who do not have 500 in...

SQL Queries to Develop SQL statements. Develop SQL statements using the EMP and DEPT tables explained in the lecture notes and available in Oracle APEX. Use Oracle APEX to try out and test each SQL...

This are the names that you will be using. DEPTNO, DNAME, LOC, EMPNO,ENAME,JOB,MGR,HIREDATE,SAL 1. Create a SQL query that will use the count function to return the number of employees in each...

PS7 1. Create a SQL query that will use the count function to return the number of employees in each department in the emp table. Include the deptno column in your SQL query. In this example you will...

Use the relative ionic radii in Fig. 13.8 to predict the structures expected for CsBr and KF. Do these predictions agree with observed structures? The ionic radius of Cs+ is 169 pm. Figure 13.8 Lit...

If you are twice as likely to find an electron at a distance of 0.0400 nm than 0.0500 nm from the nucleus, what is the ratio of the absolute value of the wave function at 0.0400 nm to that at 0.0500...

What distinguishes fixed annuities from variable annuities? Fixed annuities provide a stable interest rate, while variable annuities fluctuate with market performance Fixed annuities offer a wide...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...