Have you noticed something strange about the query for the purchase rate?
SELECT 100 * COUNT(CASE WHEN status = 'customer' THEN id END) / COUNT(*) AS purchase_rate FROM users WHERE signup_date BETWEEN '2018-01-01' AND '2018-01-07'
The result should look something like this (just an example number, real query result might be different):
You’ll see a lot of examples of tables throughout the course. Please, keep in mind that the main purpose of such examples is to reflect the structure of the query results, not the actual...