mercredi 3 juin 2015

SUM and IF operator with SQL

I have a column in a table with values of 1 given to users who purchase a trial, and 0 given to users who do not. I want the total of users who have purchased the trial. The unique identifier in the table is given by user_id.

Will the IF operator work? Can anyone explain why or why not?

Aucun commentaire:

Enregistrer un commentaire