Direction:

Use the Employees table (copy and paste the code in SQL command line)

Based on the given table: Employees table as shown below, write the PL/SQL that applies single row function in order to get the printed output per number. Write your answer in a short bond paper.

1.Create a query that display the maximum lastname concatenated to firstname and rename the column as Employees Name, Job_id and apply the ff. functions:

Count for the distinct Job_id; Apply where condition whose lastname ends with letter N; Group the job_id; and Apply having clause of employees having average salary that is greater that 10000.

Possible Output

Employees NameJOB_IDCOUNT(JOB_ID) JOB_ID

--------------------- ---------- ------------- ----------

De Haan,LexAD_VP1 AD_VP

2.What is the main goal of using GROUP BY clause?

3.What is the difference between where condition and HAVING clause?

kindly please help me about this question...thank you