Printable View
homework problems? :)
the simpliest way for point 1:
select count(*), 'Group 1' from article where sell_pr between 0 and 100
union
select count(*), 'Group 2' from article where sell_pr between 101 and 200
union
select count(*), 'Group 3' from article where sell_pr between 201 and 300;