Calculate the conversion rate from visits to sign-ups on a specific date. The conversion rate is defined as the ratio of the number of signups to the number of visits on that date.
Write an SQL query to calculate the conversion rate on a given date.
Your query should return one column:
- conversion_rate
Hint: You can use subqueries to count the number of visits and signups separately and then calculate the conversion rate. Round your answer to 2 digits.