SQL · ByteDance · Easy
Description Two tables are provided: signups and texts. Table: signups Table: texts The email_id column connects the two tables. Every texts row represents a confirmation text sent to a user. Determine the signup activation rate, defined as the proportion of TK users who confirmed their signup through a text message. Return the rate as a decimal rounded to two decimal places. A user can receive more than one confirmation text before activating, and only users listed in…
Checking your access…