240718 TIL

SQL

 

 

SELECT  substr(s.sales_date,1,4) YEAR,
        substr(s.sales_date,6,2) MONTH,
        i.gender GENDER,
        count(distinct i.user_id) USERS
from online_sale s left join user_info i on s.user_id=i.user_id
where i.gender is not null
group by 1,2,3
order by 1,2,3 asc

 

 

Ptyhon

 

plt.rc('font', family='Malgun Gothic')                   # 깨진 한글 폰트 해결
plt.rcParams['axes.unicode_minus'] = False               # 음수 해결