Hi. I have following task.
1) Find number of orders for the different shipping fee.
The result should be like:
And so on.
I was thinking abount a while loop in sql, but don´t know how:
while (select distinct shippingfee from orders)
select count(orderid) from orders where shippingfee = shippingfee
Can somebody help me?