Below are all the concepts with in course queries I learnt during my "Advanced SQL: Learn SQL Functions and Formulas" from upGrad. Check out the other .md files for the rest of the content. renames ...

select ord_id, round(sales) as rounded sales, customer name, rank() over (order by sales desc) as sale_amount_rank from market_fact_full inner join cust_dimen using ...