SQL analyzing Business Metrics 11/12 part 2


#1

SQL analyzing Business Metrics 11/12 part 2

Error: near line 1: near "as": syntax error



select name, round(1.0 * count(distinct order_id) /
count(distinct orders.delivered_to), 2) as reorder_rate
from order_items
join orders on
orders.id = order_items.order_id
group by 1
order by 2 desc;


Replace this line with your code.


#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.