스타르타코딩 SQL 강의 숙제 쿼리

그동안 숙제로 했던 코드들

 

SELECT * FROM point_users;


SELECT * FROM orders;

SELECT * FROM point_users pu INNER JOIN orders o on pu.user_id = o.user_id;

SELECT payment_method, round(AVG(point)) FROM point_users pu INNER JOIN orders o on pu.user_id = o.user_id
GROUP BY payment_method;

SELECT * from enrolleds;
SELECT * from users;

SELECT name, count(*)  as cnt from enrolleds e inner join users u on e.user_id = u.user_id
WHERE e.is_registered = 0
GROUP by name order by cnt desc;

SELECT * from courses;
SELECT * from enrolleds;

SELECT e.course_id, title, count(*) FROM courses c inner join enrolleds e on c.course_id = e.course_id
WHERE e.is_registered = 0 GROUP by e.course_id;


select e.enrolled_id, e.user_id, count(done=1) AS max_count from enrolleds e inner join enrolleds_detail ed on e.enrolled_id = ed.enrolled_id
where done =1 Group by enrolled_id order by count(done=1) DESC;

 

3월 sql 셤 홧팅!!!!