Create Ranking List & Current Date

1. Ranking List

Select coulmn_name(1), coulmn_name(2), Sales_coulmn_name(3), dense_rank() over(order by Sales_coulmn_name desc) as  Ranking from table_name

You Can use "where condition" and "limit"

Example

Select listing_Id, buyer_city_repo, delivered_gmv, dense_rank() over(order by delivered_gmv desc) as Ranking from category.food_fmcg_sales
Where buyer_city_repo in ('Delhi')
Limit 9

Output

2. Current Date

Select coulmn_name(1), coulmn_name(2), Sales_coulmn_name(3), 

current_Date() as Today_Date

from table_name

Example

Select listing_ID, buyer_org_name, order_first_shipped_date, 

current_Date() as Today_Date

from category.food_fmcg_sales

Limit 15

Output