4th is in error here is the solution SELECT e.emp_name AS name, e.salary, e.commission, (e.salary + e.commission) AS netpay, m.manager_name FROM employees e JOIN manager m ON e.manager_id = m.manager_id WHERE (e.salary + e.commission) > ( SELECT MIN(salary + commission) FROM employees WHERE manager_id IS NOT NULL ) AND e.manager_id IS NOT NULL; exit;
for 1 getting Incorrect answer. **Status Count** Active 15 Terminated 5 **Employees under Terminated Manager** emp_id emp_name Mgr_name Mgr_Status Mgr_Supervisor 9 Jismin Luis Nisa Sebastian Terminated John Mateo 11 Anna Liam Matt Daniel Terminated Krishna James
@@TechnonTechTVset serveroutput on; declare act number; ter number; mgrname varchar2(200); mgr_sup varchar2(200); superv varchar2(200); cursor curr is select emp_id, concat(emp_fname,concat(' ',emp_lname)) as empname, emp_status from emp; cursor curr2 is select superv, concat(e.emp_fname,concat(' ',e.emp_lname)) as mgrname, e.emp_status as stat, e.mgr_id as mgr1 from emp e, emp a where a.mgr_id=e.emp_id; c1 curr%rowtype; c2 curr2%rowtype; begin select count(emp_id) into act from emp where emp_status='Active'; select count(emp_id) into ter from emp where emp_status='Terminated'; dbms_output.put_line('**Status Count**'); dbms_output.put_line('Active '||' '||act); dbms_output.put_line('Terminated '||' '||ter); dbms_output.put_line('**Employees under Terminated Manager**'); dbms_output.put_line('emp_id emp_name Mgr_name Mgr_Status Mgr_Supervisor'); open curr; open curr2; loop fetch curr into c1; fetch curr2 into c2; exit when curr%notfound; if c2.stat='Terminated' and c1.emp_status='Active' then select concat(emp_fname,concat(' ',emp_lname)) into superv from emp where emp_id=c2.mgr1; dbms_output.put_line(c1.emp_id||' '||c1.empname||' '||c2.mgrname||' '|| c2.stat||' '||superv); end if; end loop; end; / /* Enter your query below. Please append a semicolon ";" at the end of the query */ exit;
Thank you very much. This video was helpful
Glad to hear this. Keep Learning:)
@@TechnonTechTVgetting error on the 4th code please help me
4th is in error here is the solution SELECT
e.emp_name AS name,
e.salary,
e.commission,
(e.salary + e.commission) AS netpay,
m.manager_name
FROM
employees e
JOIN
manager m ON e.manager_id = m.manager_id
WHERE
(e.salary + e.commission) > (
SELECT
MIN(salary + commission)
FROM
employees
WHERE
manager_id IS NOT NULL
)
AND
e.manager_id IS NOT NULL;
exit;
working
Thank you soo much 👍👍👍
Last question is throwing error
thank you
Excellent .very helpful .Request you to provide answers for course id 73740 (core java E1 ion assessment )
Where we get mcq after handson ? Any one any idea
Can help us on the last assignment..the question is slightly bit change hence unable to clear the exp
** inner join manager m on e.manager_id = m.manager_id
@@arjunsekhar4033 in which line could you please let me know?
Can you provide solutions for Plsql e1 hands-on frescoplay please
Hi Sayanth, I just uploaded PLSQL E! handson solution on my channel. Please check it.
Pls tell me what is the error from my side i only follow your code
Hi I am able to run all solutions with test cases pass but at end get failed at final submission
can you help me in this pls?
Hi
It gets completed after some days.
Same I have run all test cases and submit at last got you have not passed the assessment
Do I need to attempt again?
Yes it's Fresco play issue. You need to retry it.
Yes I am facing same
Hi
Can you please also give answers for mini project clp javascript e2?
I put your code only again i got error
Hi bro that last assesment pls help.
Course id
👌👌👌
Please do 62001 ievolve core java e2
👍👍👍
The last question is showing some incorrect answer for some test case
1st question answer is not "All of the above"
Quiz has different questions which we are unable to answer . If anyone has all the 10 questions answer please send them to
Hii, all the program is working fine for you?
1,2,3 showing errors for me
I am getting 4 th code error
Join with manager and pull out manager name from it..
Can you post the 4th code
Fresco play answers
for 1 getting Incorrect answer.
**Status Count**
Active 15
Terminated 5
**Employees under Terminated Manager**
emp_id emp_name Mgr_name Mgr_Status Mgr_Supervisor
9 Jismin Luis Nisa Sebastian Terminated John Mateo
11 Anna Liam Matt Daniel Terminated Krishna James
Please send your code on technontechtv@gmail.com will check and get back to you
Did you get correct answer?
@@TechnonTechTVset serveroutput on;
declare
act number;
ter number;
mgrname varchar2(200);
mgr_sup varchar2(200);
superv varchar2(200);
cursor curr is select emp_id, concat(emp_fname,concat(' ',emp_lname)) as empname, emp_status from emp;
cursor curr2 is select superv, concat(e.emp_fname,concat(' ',e.emp_lname)) as mgrname, e.emp_status as stat, e.mgr_id as mgr1 from emp e, emp a where a.mgr_id=e.emp_id;
c1 curr%rowtype;
c2 curr2%rowtype;
begin
select count(emp_id) into act from emp where emp_status='Active';
select count(emp_id) into ter from emp where emp_status='Terminated';
dbms_output.put_line('**Status Count**');
dbms_output.put_line('Active '||' '||act);
dbms_output.put_line('Terminated '||' '||ter);
dbms_output.put_line('**Employees under Terminated Manager**');
dbms_output.put_line('emp_id emp_name Mgr_name Mgr_Status Mgr_Supervisor');
open curr;
open curr2;
loop fetch curr into c1;
fetch curr2 into c2;
exit when curr%notfound;
if c2.stat='Terminated' and c1.emp_status='Active' then
select concat(emp_fname,concat(' ',emp_lname)) into superv from emp where
emp_id=c2.mgr1;
dbms_output.put_line(c1.emp_id||' '||c1.empname||' '||c2.mgrname||' '|| c2.stat||' '||superv);
end if;
end loop;
end;
/
/*
Enter your query below.
Please append a semicolon ";" at the end of the query
*/
exit;
All code run successfully but Fresco play failed
@@anupamyadav5257is it resolved now?
Make a vedio on spring boot hands on course I'd 55960 & 55962
Pls give me a answer
Hi bro
Hi
Bro help me bro
Hi bro