밍아카이브

*solveSql은 문제를 게시하는 걸 금하기 때문에 답만 첨부https://solvesql.com/problems/main-platform-of-game-developers/문제유형 : Window function 난이도4 with developer_platform_sales as ( SELECT developer_id ,platform_id ,sum(sales_na + sales_eu + sales_jp + sales_other) total FROM games WHERE developer_id IS NOT NULL group by developer_id, platform_id), rank_sales as ( select developer_id ,platform_id , tota..

*solveSql은 문제를 게시하는 걸 금하기 때문에 답만 첨부https://solvesql.com/problems/top-3-bill/https://solvesql.com/problems/summary-of-artworks-in-3-years/문제유형 : WINDOW FUNCTION난이도4 with tb_rank as ( select day, time, sex, total_bill, rank() over(PARTITION by day order by total_bill desc ) rank_bill from tips) select day, time, sex, total_billFROM tb_rankwhere rank_bill

*solveSql은 문제를 게시하는 걸 금하기 때문에 답만 첨부https://solvesql.com/problems/refine-cafe-address/문제유형 : String/Date난이도3 WITH parsed_cafes AS ( SELECT SUBSTR(address, 1, INSTR(address, ' ') - 1) AS sido, SUBSTR( address, INSTR(address, ' ') + 1, INSTR(SUBSTR(address, INSTR(address, ' ') + 1), ' ') - 1 ) AS sigungu FROM cafes)SELECT sido, sigungu, COUNT(*) AS cntFROM parsed_ca..

*solveSql은 문제를 게시하는 걸 금하기 때문에 답만 첨부https://solvesql.com/problems/predict-game-scores-1/문제유형 : Analytics난이도3 -- with tb_avg as (-- select -- genre_id-- ,round (sum(critic_score*critic_count)/sum(critic_count),3) 'avg_critic'-- ,CEIL(AVG(critic_count)) 'cnt_critic'-- ,round(sum(user_score*user_count) / sum(user_count) , 3) 'avg_user'-- ,CEIL(AVG(user_count)) 'cnt_user'-- from games--..

*solveSql은 문제를 게시하는 걸 금하기 때문에 답만 첨부https://solvesql.com/problems/day-of-furniture/문제유형 : CASE/IF난이도4 select order_date , count( DISTINCT (case when category='Furniture' then order_id end) ) furniture , round( ( count( DISTINCT (case when category='Furniture' then order_id end) ) / cast(count(distinct order_id)as real) )*100 ,2) furniture_pctfrom recordsgroup by o..

1. Mosquito numbers are rising nationwide as temperatures cool ahead of autumn, with Busan reporting 1,020 mosquitoes collected in the first week of September, or a 27 percent increase over the August weekly average of 802 2. Koreas's car ecports to the US fell for the sixth consecutive month in Auguest, dropping 15 percent from a year earlier, hit hard by the Trump administration's tariffs. 3. ..

*solveSql은 문제를 게시하는 걸 금하기 때문에 답만 첨부https://solvesql.com/problems/summary-of-artworks-in-3-years/문제유형 : CASE/IF난이도2SELECT classification ,SUM(IIF(STRFTIME('%Y',acquisition_date)='2014',1,0)) '2014' ,SUM(IIF(STRFTIME('%Y',acquisition_date)='2015',1,0)) '2015' ,SUM(IIF(STRFTIME('%Y',acquisition_date)='2016',1,0)) '2016' FROM artworksGROUP BY classificationORDER BY classification

*solveSql은 문제를 게시하는 걸 금하기 때문에 답만 첨부https://solvesql.com/problems/data-without-underscore/문제유형 : STRING/DATE난이도2SELECT DISTINCT page_location FROM gaWHERE page_location NOT GLOB '*_*'