if / Else / Else if / statement in sql

Question

I have a query that goes something like this:

SELECT SUM(`table`.points) AS total_points FROM table

This will return something like this

|    **points**   |
        324

Now I want to add another result next to it depending on the total points that the user has and display it. Below is the sample that I am trying to achieve

if (total_points >= 50 && < 100) {
  //display another column next to the points
  another_rows AS total_points + 50  
} else if (total_points >= 100 && < 200) {
  another_rows AS total_points + 100  
} else if (total_points >= 200 && < 300) {
  another_rows AS total_points + 200  
} else if (total_points >= 300 || 300) {
  another_rows AS total_points + 300  
} else {
  another_rows AS total_points
}

Desire results:

|    **points**   |     **another_row**   |
        324                   824

Answer 1

SQL has a construct called CASE for these usecases exactly:

SELECT SUM(points) AS total_points,
       SUM(points) +
       CASE 
         WHEN SUM(points) BETWEEN 50 AND 100 THEN 50
         WHEN SUM(points) BETWEEN 100 AND 200 THEN 100
         WHEN SUM(points) BETWEEN 200 AND 300 THEN 200
         WHEN SUM(points) BETWEEN 300 AND 400 THEN 300
         ELSE 500
       END AS another_row
FROM  `table`