0

Write a sql query to fetch the department wise count of students who passed/failed exm for each year.

Columns to be fetched : dept_name, year_1 , year_2, year_3, year_4 Year_ to year_4 should display the count of students who cleared and count of students who failed. Separate pass and fail count with comma separator (Ex:P=1, F=1) for each year.

6th Aug 2021, 10:16 AM
VGraja Priya
VGraja Priya - avatar
1 Respuesta
+ 3
VGraja Priya I encourage you to post your attempt. We cannot correct your mistakes without seeing what you tried. It looks like you have not begun the SQL tutorial here. The tutorial might be worthwhile if you need help getting started with this task. You can find the SQL tutorial here: https://www.sololearn.com/Course/SQL/?ref=app
6th Aug 2021, 12:21 PM
Brian
Brian - avatar