Practical SQL Data Analysis: Efficient Data Processing and Generating Insights
From SQL basics to practical analysis! Learn powerful SQL skills to solve business problems by extracting, transforming, and analyzing data.
11 learners are taking this course
Level Beginner
Course period Unlimited
Want to know what questions other learners frequently ask?
- Unresolved
12-2 listing 로드 문제
load할 때 id에 중복값이 있어서 고유키 설정인 안되는데 어떻게 해결하나요
sqlmysqldbms/rdbmscsd88500353
・
a year ago
0
66
2
- Unresolved
2-2. 실습 2A 6, 7번 문제
Ex 7. # fact_orders 테이블에서 product id 순으로 다음 10개의 제품을 표시하세요 select product_id, prod_cat_name_eng from ecommerce.dim_products order by product
sqlmysqldbms/rdbmscsd88500353
・
a year ago
0
65
1
- Unresolved
12_5 질문3
3번 질문에서 1년 동안 완전히 이용 가능한 listings를 찾기 위해서 SELECT COUNT(DISTINCT id)FROM openairbnb.listings AS lWHERE l.availability_365 = 365;<b
sqlmysqldbms/rdbmsyseohyun119795
・
0
64
3
- Unresolved
12_6강 질문
4번 문제를 혼자 먼저 풀어볼 때,SELECT COUNT(DISTINCT l.id)FROM opena
sqlmysqldbms/rdbmsyseohyun119795
・
0
73
2