SELECT min(profit) as worst_deal from orders SELECT segment, round(sum(profit)) as total_profit_segmentfrom ordersgroup by segment  That's all for today.

Order IDs: Unique vs Distinct: Seriously, it does not support count(distinct ID)..?!  select [Sub-Category], round(sum(profit))from ordersgroup by [Sub-Category]order by sum(profit) desc Better do something with those tables. SELECT year(order_date),round(sum(profit))from orders…

With duplicate checker:

with prep as (SELECT * except (description, image_thumbnail) FROM `properati-data-public.properties_ar.properties_sell_201511` where price is not null and price != 0), average_usd as (select concat(extract(year from created_on),'-',extract(month from created_on)) as yearmonth,round(avg(price),0) as…