6/17 sql group by

use school;

create table products(
 productId char(4) not null primary key,
 productName varchar(50) not null,
 productType varchar(10) not null,
 price int not null,
 expire varchar(10) null
);

insert into products(productId,productName,productType,price)
values('0001','아이폰6','smartphone',1000000);
insert into products(productId,productName,productType,price)
values('0002','갤럭시s7','smartphone',1000000);
insert into products(productId,productName,productType,price)
values('0003','닥터드레','headphone',200000);
insert into products(productId,productName,productType,price)
values('0004','뱅앤올룹슨','headphone',300000);
insert into products(productId,productName,productType,price)
values('0005','아이리버','mp3',500000);

select * from products;