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.
select if(grades.grade<8,concat("NULL"),students.name),grades.grade,students.marks
from students inner join grades
on(students.marks>=grades.min_mark and students.marks<=grades.max_mark
)
group by grades.grade desc, students.name,students.marks desc;
the query say that students marks greater than or eql minimum mark and less than or eql ...see the grade table then think about input and output ....thats make u clear ...Happy Coding!!!
select (case when grade <8 THEN NULL ELSE name END) name, grade, marks
from students,grades
where marks between min_Mark and Max_Mark
order by grade desc, name, coalesce(name,marks);
there is no need to give orderby name 2 times one outside an other inside coalesce
select (case when grade <8 THEN NULL ELSE name END) name, grade, marks from students,grades where marks between min_Mark and Max_Mark order by grade desc, coalesce(name,marks);
don't get confuse if you don't see an 'asc' keyword in many above soln. here r 2 query both identical and do same work
select (case when g.grade > 7 then s.name else Null end), g.grade, s.marks
from students s, grades g
where s.marks between g.min_mark and g.max_mark
order by g.grade desc, s.name, s.marks asc
select (case when g.grade > 7 then s.name else Null end), g.grade, s.marks
from students s, grades g
where s.marks between g.min_mark and g.max_mark
order by g.grade desc, s.name, s.marks
The Report
You are viewing a single comment's thread. Return to all comments →
can you please explain "where marks between min_Mark and Max_Mark" this part
Here is my MYSQL Soln:
select if(grades.grade<8,concat("NULL"),students.name),grades.grade,students.marks from students inner join grades on(students.marks>=grades.min_mark and students.marks<=grades.max_mark ) group by grades.grade desc, students.name,students.marks desc;
@tasfiahm
Thanks
this will also work for mysql
select (case when grade <8 THEN NULL ELSE name END) name, grade, marks from students,grades where marks between min_Mark and Max_Mark order by grade desc, name, coalesce(name,marks);
@rupalvshinde the coalesce in the end might not work as both the column name and marks have different data type.
why use coalese() function
Thanks for the solution. What I learnt: '>' != '>=' :)
isn't it should be marks asc? because
there is no need to give orderby name 2 times one outside an other inside coalesce
Thank you ji.
Helpful. Thank you!
don't get confuse if you don't see an 'asc' keyword in many above soln. here r 2 query both identical and do same work