[엘리스 SQL] SQL 문제집 - 세 번째 이야기 문제 모음

https://hrd-demo.elice.io/courses/4998/lectures/all

SQL 문제집 | hrd-demo

 

1. 쪽지시험 성적 분석하기

select avg(score) from student;
select max(score),min(score) from student;
select * from student order by score desc limit 3;

 

2. 쪽지시험 성적 분석하기 2

select count(*) from student where score>80;
select name from student order by score desc limit 1;
select grade, avg(score) from student group by grade;

 

3. 학점 계산하기

alter table student add score float;
update student set score = (midterm+final)*4.5/200;
select name, score from student;

 

4. 신체 검사표

select gender, avg(height), avg(weight) from student group by gender;

select weight from student where gender='M' order by height desc limit 1;

select weight from student where gender='F' order by height asc limit 1;

 

5. 주주총회

이거 진짜 맞게 풀었고 다른 분들도 다 나랑 코드 같은데 틀렸다고 나와서 이의제기했다

피드백 반영 해주시길...

 

2024-03-14: 피드백 반영이 되었다는 메일을 받았다 ㅎㅎ 

select stock from shareholder where name in ("Alexis", "Craig", "Fred");
select name, stock from shareholder where agree = 0 and stock >= 100000;
select name, stock from shareholder where agree = 1 and stock >= 100000;