We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Join
- The Report
- Discussions
The Report
The Report
Sort by
recency
|
3113 Discussions
|
Please Login in order to post a comment
MS SQL SERVER
MySQL:
MY SQL SELECT 5 CASE 6 WHEN g.grade < 8 THEN 'NULL' 7 ELSE s.name 8 END AS name, 9 g.grade, 10 s.marks 11 FROM students s 12 INNER JOIN grades g 13 ON s.marks BETWEEN g.min_mark AND g.max_mark 14 ORDER BY g.grade DESC, s.name;