select concat('concat',' ', 'test');
concat test
select concat(string1, column) from celeb;
string1과 column의 value들을 연결해서 조회
select columm (as) column_alias from table_name (as) table_alias;
select concat(s.season,'-',s.episode, '(',s.broadcast_date,')') '방송정보',
concat(c.name, '(', c.job_title,')') '출연자정보'
from celeb c, snl_show s
where name = host;
select distinct column1, column2, ...
from table_name
where condition;
select agency from celeb;
select distinct agency from celeb;
select column1, column2...
from table_name
where condition
order by column
limit number;
select * from celeb where sex = 'M' order by age DESC limit 2;
celeb 테이블에서 남자 연예인 중 나이가 가장 많은 2명 조회