Im using SQL on a mac. How do I do this in SQL code

Use a number table to loop from 1 to 100 and return the count of DVD within that price range. (hint: Use a scalar sub-query.) Example: DVDs between $1.01 and $2.00 = 209

Use a number table to loop from 0 to 16. Then include an inline view to find the number of vehicles with the matching number of cylinders built in 2012. Use a case statement to replace null values with a 0. (hint: there were 9 vehicles with 0 cylinders built in 2012.)