SQL · Google · Easy
Description You are given a table named ad_campaigns that holds performance data for advertising campaigns. > > >The campaign_id column is the primary key. Each record contains the total amount spent and the total revenue earned for a single campaign. Your task is to compute the Return on Ad Spend (ROAS) for every campaign. ROAS is calculated as revenue / spend, and the result must be rounded to two decimal places. Return a result set with the columns campaign_id and roas.…
Checking your access…