목록2024/04/29 (1)
짜리몽땅 매거진
![](http://i1.daumcdn.net/thumb/C150x150/?fname=https://blog.kakaocdn.net/dn/b1LTjS/btsG2UQ4iFz/P92T0Xl7awlmnSvx8hJ1S0/img.png)
문제1. 레스토랑의 일일 매출출처 : solvesql 연습문제문제 정보 : 난이도 2 / 정답률 69.23%https://solvesql.com/problems/daily-revenue/ https://solvesql.com/problems/daily-revenue/ solvesql.com 정답 쿼리select day, sum(total_bill) as revenue_dailyfrom tipsgroup by dayhaving revenue_daily >=1000order by revenue_daily desc 문제 해설문제2. 쇼핑몰의 일일 매출액과 ARPPU출처 : solvesql 데이터리안 sql캠프 입문반문제 정보 : 난이도 3 / 정답률 37.09%https://solvesql.com/prob..
Data/SQL
2024. 4. 29. 13:27