Reference no: EM132111175
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 be grouping by deptno.
Copy and paste your code into your assignment and include a screenshot of your result set in your assignment.
2. Modify the previous SQL query to use the single-row function DECODE() to change the deptno into the name of the department. You will have to look at the dept table to get the name of each department given the deptno.
Copy and paste your code into your assignment and include a screenshot of your result set in your assignment.
3. Modify the previous query to show the departments that have only 4 or more employees. So now you will be using the count(*) function in both the ordered list of columns and conditional clause.
Copy and paste your code into your assignment and include a screenshot of your result set in your assignment.
4. Create a SQL query that will give the total amount of salary and commission paid out for each job for one year, GROUP BY job. Assume that the sal column means salary paid every two weeks, so you will have to multiply sal by 26 and add the commission, but the commission is paid for 1 month. Remember many employees have NULL in their commission field so you will have to use the NVL() single row function or the SUM() function will not work correctly.
Copy and paste your code into your assignment and include a screenshot of your result set in your assignment.
5. Modify the previous SQL query to show only those jobs that paid out more than $150,000 in salary and commission last year. In the having clause you can use the SQL code that was used to find the total sum of salary and commission.
Copy and paste your code into your assignment and include a screenshot of your result set in your assignment.
|
Write the matlab code lines that add 2 to the value
: Provide the matlab syntax that will ask a user at the command window to enter a name and assign the name to a variable called 'name'.
|
|
Write a sql query that shows the empno
: Write a SQL query that shows the empno, ename, job and total salary for all employees from the emp table and uses a sub-query to show employees.
|
|
Create a sql query that lists the id and policy id
: Create a SQL query that lists the ID, Policy ID, county, construction and line for residential properties between Clearwater in the south.
|
|
Write a sql query that will give the employee number
: Write a SQL query that will give the employee number, employee name and hired date from the EMP table.
|
|
Create a sql query that will use the count function
: Create a SQL query that will use the count function to return the number of employees in each department in the emp table.
|
|
A program to simulate signals of a pedestrian traffic light
: Specifically, the car lantern will light up for 10 seconds, then turn off and turn on the pedestrian traffic light for 7 seconds.
|
|
Create a sql query in the sql command window showing
: Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate from the emp table.
|
|
Identify all of the structural constraints
: Identify all of the structural constraints. ER diagram required using CHEN'S notation with list of assumptions made.
|
|
Design a program that continuously accepts
: Design a program that continuously accepts an author's name, number of books Written, and target reader age until a sentinel value is entered.
|