Breaking News: Grepper is joining You.com. Read the official announcement!

PL-SQL: mm-dd for subqueries and different columns

Sumaia Parveen Shupti answered on May 12, 2022 Popularity 1/10 Helpfulness 1/10

answer PL-SQL: mm-dd for subqueries and different columns

PL-SQL: mm-dd for subqueries and different columns

Comment

select sales_2021.sales_day_2021 as sales_day, 
sales_2021.profit_2021, 
sales_2022.profit_2022, 
sales_2021.unit_count_2021, 
sales_2022.unit_count_2022,
sales_2021.sales_2021, 
sales_2022.sales_2022,
round((sales_2022.profit_2022 - sales_2021.profit_2021)*100/sales_2021.profit_2021, 2) as yoy_profit_pct,
round((sales_2022.unit_count_2022 - sales_2021.unit_count_2021)*100/sales_2021.unit_count_2021, 2) as yoy_inv_pct,
round((sales_2022.sales_2022 - sales_2021.sales_2021)*100/sales_2021.sales_2021, 2) as yoy_sales_pct
from
(select ltrim(TO_CHAR(TO_DATE(sold_dt,'dd/mm/yyyy'),'mm-dd'),'0') as sales_day_2022,
count(sold_id) as unit_count_2022, 
sum(sold_price-usd_dealer_payable) as profit_2022,
sum(sold_price) as sales_2022
from inv.item_sold
where trunc(sold_dt) between to_date('01-JAN-22') and to_date('10-MAY-22') 
and channel = 'EBAY2'
group by ltrim(TO_CHAR(TO_DATE(sold_dt,'dd/mm/yyyy'),'mm-dd'),'0')) sales_2022
join
(select ltrim(TO_CHAR(TO_DATE(sold_dt,'dd/mm/yyyy'),'mm-dd'),'0') as sales_day_2021,
count(sold_id) as unit_count_2021, 
sum(sold_price-usd_dealer_payable) as profit_2021,
sum(sold_price) as sales_2021
from inv.item_sold
where trunc(sold_dt) between to_date('01-JAN-21') and to_date('10-MAY-21') 
and channel = 'EBAY2'
group by ltrim(TO_CHAR(TO_DATE(sold_dt,'dd/mm/yyyy'),'mm-dd'),'0')) sales_2021
on sales_2021.sales_day_2021 = sales_2022.sales_day_2022
order by sales_2021.sales_day_2021 asc

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on May 12 2022

Sumaia Parveen Shupti

0 Answers Avg Quality 2/10

PL-SQL: mm-dd for subqueries and different columns

Contents

More Related Answers

PL-SQL: mm-dd for subqueries and different columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.