1) To display branchwise count of students in descending order, you can use the COUNT() function and GROUP BY statement. The query would look like this:

```sql
SELECT Branch, COUNT(*) AS 'Number of Students'
FROM Student_Result
GROUP BY Branch
ORDER BY COUNT(*) DESC;
```

2) To display the roll no, name, and mentor of students who got less than 9 marks in any subject, you can use the WHERE clause to filter out the students. The query would look like this:

```sql
SELECT Roll_No, Name, Mentor
FROM Student_Result
WHERE DBMS

Question

1) To display branchwise count of students in descending order, you can use the COUNT() function and GROUP BY statement. The query would look like this:

```sql
SELECT Branch, COUNT(*) AS 'Number of Students'
FROM Student_Result
GROUP BY Branch
ORDER BY COUNT(*) DESC;
```

2) To display the roll no, name, and mentor of students who got less than 9 marks in any subject, you can use the WHERE clause to filter out the students. The query would look like this:

```sql
SELECT Roll_No, Name, Mentor
FROM Student_Result
WHERE DBMS < 9 OR DS < 9 OR JAVA_II < 9 OR MATHS_II < 9;
```

3) To display the branchwise maximum total marks of all subjects, you can use the MAX() function and GROUP BY statement. The query would look like this:

```sql
SELECT Branch, MAX(DBMS + DS + JAVA_II + MATHS_II) AS 'Maximum Total Marks'
FROM Student_Result
GROUP BY Branch;
```

Knowee AI · Accepted Answer

1) To display branchwise count of students in descending order, you can use the COUNT() function and GROUP BY statement. The query would look like this:

```sql
SELECT Branch, COUNT(*) AS 'Number of Students'
FROM Student_Result
GROUP BY Branch
ORDER BY COUNT(*) DESC;
```

2) To display the roll no, name, and mentor of students who got less than 9 marks in any subject, you can use the WHERE clause to filter out the students. The query would look like this:

```sql
SELECT Roll_No, Name, Mentor
FROM Student_Result
WHERE DBMS < 9 OR DS < 9 OR JAVA_II < 9 OR MATHS_II < 9;
```

3) To display the branchwise maximum total marks of all subjects, you can use the MAX() function and GROUP BY statement. The query would look like this:

```sql
SELECT Branch, MAX(DBMS + DS + JAVA_II + MATHS_II) AS 'Maximum Total Marks'
FROM Student_Result
GROUP BY Branch;
```

Question

Solution

Similar Questions

Upgrade your grade with Knowee