SQL · Meta · Medium
Given three SQL tables—ad, impression, and conversion—write a query that reports the Click-Through Rate (CTR) for every advertisement. CTR is the number of clicks divided by the number of impressions. Specifications: The ad table stores identifying information for each advertisement. The impression table stores impression totals associated with advertisements. The conversion table stores click totals associated with advertisements. Create an SQL query that returns each ad's…
Checking your access…