How do I combine multiple calculations in MySQL unsing a single SQL statement?

See more:

MySQL-Connector

Hi guys,
I´m new to MySQL , so I would need some help. I´m writing my master thesis where I need to use SQL statements in order to get data from MySQL into a visualization software (software is called tableau) but I´m totally swamped :( would really appreciate your help!! Thanks a lot in advance! Best, Désirée
Here is my question: how do I get the following 4 calculations in one SQL statement:
• Database: is called foto
• The table rate_changes: contains following variables:
o Is_trial
o Is_conversion
o Is_churn
o Is_upgrade
o Is_downgrade
o Id
o Photographer_id
o Qualification
o Marketing_channel_id
o Kid
o Affiliate_id
o Old_rate_id
o New_rate_id
o Created
In order to calculate the # subscribers I need to do the following calculations:
(I write it down in a kind of meta language which is just a mix of SQL and the description of what I want to do, because I don´t know the correct SQL code)
Calculation 1:

Select count (foto.rate_changes.photographer_id)
From foto.rate_changes
Where foto.rate_changes.is_conversion = 1;

Calculation 2:

Select count (foto.rate_changes.photographer_id)
From foto.rate_changes
Where foto.rate_changes.is_churn= 1;

Calculation 3: result (calculation 1) – result (calculation 2)
Calculation 4: running sum of calculation 3 -->then you have the # subscribers per month