Oracle SQL Practical question with answer Compute Student Result Dashboard

Oracle SQL Practical question with answer Compute Student Result Dashboard

[sriharsha]

Hi Shiva, I got to know about your videos while I was searching for right content to prepare for Interviews. Your videos are absolutely useful, though I have experience on Sql/Plsql, still every video of yours give me new info which I am not aware of. Great Job. Keep doing 👍

[himanshumittal]

The topics and questions that you have covered in your videos are great for the interviews and learning new concepts. Thanks for sharing. Great Work. (Y).

[vanihavisharavipati]

I can say that your channel is the best for learning SQL concepts. I wish I know your channel before..even though I worked as a Data analyst..I learned new concepts from your channel..thank you so much for your great work...all the videos are crisp, and well explained with details...looking forward for new videos too..

[sachinbhall]

Each video is teaching something new. Thanks for ur efforts.

[SanjayKumar-ngzp]

Hi Sir, Very Informative videos, learning a lot. I have one request please provide table structure and dml scripts with videos. Thanks

[vikaskumar-qrtj]

Really beautiful video explaining the concept it was just superb ....

[hariprasath]

You are great shiva 👍Expecting more excercise videos from you u will do it ....

[purnachandrasahoo]

with
temp as
(select dept, year, sum(case result
when 'P' then
1
else
0
end) as pass,
sum(case result
when 'F' then
1
else
0
end) as FAIL
from student
--where dept = 'EEE'
group by dept, year)

select dept,
'P = '||max(decode(year, 1, pass, null))||
', F = '||max(decode(year, 1, fail, null))as year_1,
'P = '||max(decode(year, 2, pass, null))||
', F = '||max(decode(year, 2, fail, null))as year_2,
'P = '||max(decode(year, 3, pass, null))||
', F = '||max(decode(year, 3, fail, null))as year_3,
'P = '||max(decode(year, 4, pass, null))||
', F = '||max(decode(year, 4, fail, null))as year_4
from temp
group by dept;

---2nd output

with
temp as
(select dept, year, sum(case result
when 'P' then
1
else
0
end) as pass,
sum(case result
when 'F' then
1
else
0
end) as FAIL
from student
--where dept = 'EEE'
group by dept, year)

select case
when year = 1 then
'YEAR :1'
when year = 2 then
'YEAR :2'
when year = 3 then
'YEAR :3'
when year = 4 then
'YEAR :4'
END as year,

'P = '||max(decode(dept, 'EEE', pass, null))||
', F = '||max(decode(dept, 'EEE', fail, null))as EEE,
'P = '||max(decode(dept, 'MECH', pass, null))||
', F = '||max(decode(dept, 'MECH', fail, null))as MECH,
'P = '||max(decode(dept, 'CVE', pass, null))||
', F = '||max(decode(dept, 'CVE', fail, null))as CVE,
'P = '||max(decode(dept, 'ECE', pass, null))||
', F = '||max(decode(dept, 'ECE', fail, null))as ECE,
'P = '||max(decode(dept, 'CSE', pass, null))||
', F = '||max(decode(dept, 'CSE', fail, null))as CSE
from temp
group by year;

[PriyankaKumari-ulbv]

please upload more videos topics wise for plsql and sql.I liked all your videos.Please share all your videos on udemy.

[parth]

Amazing content Shiva. I would like you to add a video to calculate percentile marks department wise

[somiyasaxena]

Can I do it like this: Select dept_no, no_of_years,
count(when case result = 'P' then result end) AS PASS,
count(case when result = 'F' then result end) AS FAIL
From student
group by dept_no, no_of_years)
order by (dept_no, no_of_years);

[Aaditya]

Can you please share database file / script?