34Write SQL for click-through rate by ad in October, then monthly average star ratings per Marketplace product.▼easySnowflake1 replies◆ premiumThe two reported Snowflake SQL-screen warmups. Both look trivial; both have a silent-failure trap, integer division and divide-by-zero in one, the EXTRACT(MONTH) year-collision in the other.Open full answer →
06Design a CTR and conversion-rate prediction system for ads.▼hardGoogleMetaAmazon2 repliesunlockedThis model's output is not a ranking, it is a price input. A miscalibrated CTR makes the auction bid wrong, so you overpay or underdeliver. Add conversions that land days after the click and advertisers with zero history, and calibration plus delayed feedback become the whole interview.Open full answer →