Quiz5. 집계함수

[kyohoonsim]

5-1. [SQL 쿼리] [실행화면 캡쳐]

5-2. [SQL 쿼리] [실행화면 캡쳐]

[aosdbfc]

SELECT COUNT(*) FROM student;

SELECT SUM(age),AVG(age),MAX(age),min(age) FROM student;

[YelynYoo]

5-1. select count(*) from student;

5-2. select sum(age), avg(age), max(age), max(birth) from student;

[echoe1009]

5-1. SELECT COUNT(*) FROM student;

5-2. SELECT SUM(age), SUM(age)/COUNT(age), MAX(birth), MIN(birth) FROM student;

[dhEhdod]

5-1. SELECT COUNT(*) FROM student;

5-2. SELECT SUM(age), avg(age), MAX(age), MAX(birth) FROM student;

[xinnazim]

5-1.

SELECT COUNT(*) FROM student;

5-2.

SELECT SUM(age),AVG(age),MAX(age), MAX(birth) FROM student;

[last0331]

5-1. SELECT COUNT(*) FROM student;

5-2. SELECT SUM(age), AVG(age), MAX(age), MAX(birth) FROM student;

[indianaPoly]

5-1. select count(*) from student;

5-2. select sum(age), avg(age), max(age), (select birth from student where age = ( select min(age) from student)) from student;

[aosdbfc]

[yibeeeen]

5-1 SELECT COUNT(*) FROM student;

5-2 SELECT SUM(age), AVG(age), MAX(age), MAX(birth) FROM student;

[SHINZIMIN]

5-1 SELECT COUNT(*) FROM student;

5-2 SELECT SUM(age), AVG(age), MAX(age), MAX(birth) FROM student;

[Y0nghwan]

5-1

SELECT COUNT(*) FROM student;

5-2

SELECT SUM(age), AVG(age), MAX(age), MAX(birth) FROM student;

[hungrywoo]

5-1. SELECT COUNT(*) FROM student;

5-2. SELECT SUM(age), AVG(age), MAX(age), MAX(birth) FROM student;

[expediore]

5-1. select count(*) as 총데이터갯수 from student;

5-2. select sum(age) as 나이합계, avg(age) as 평균나이, min(birth) as 가장늦은생일, max(birth) as 가장빠른생일 from student;

[WooJHo]

5-1 SELECT COUNT(*) from student;

5-2 select SUM(age),AVG(age),max(age),max(birth) from student;

[KUSFTWOO]

SELECT COUNT(*) FROM student; SELECT SUM(age), AVG(age), MAX(age), MAX(birth) FROM student;

[monimanimo]

5-1 select count(*) from student; 5-2 select sum(age), avg(age), max(age), max(birth) from student;

[JJungEunnn]

5-1

5-2

[jjjjjjye]

5-1 SELECT COUNT(email) FROM student;

*생성할때 email을 PRIMARY KEY로 지정해서 email을 통해 값을 구해봤습니다.

5-2 SELECT SUM(age), AVG(age), MIN(birth), MAX(birth) FROM student;

[echoe1009]

5-1 SELECT COUNT(*) FROM student;

5-2 SELECT SUM(age), AVG(age), MAX(age), MAX(birth) FROM student;

[BAEKDONGSEOK]

5-1

5-2

[2gyuheon]

select count(*) from student; SELECT SUM(age),AVG(age),MAX(age),min(age) FROM student;

[jeong1217]