SQLize Online / PHPize Online  /  SQLtest Online

create table tbl_KpopBG ( K_ID int identity (1,1), K_NAME varchar (150), K_COMPANY varchar (150), K_DEBUT date, K_SALES decimal (12,4), ); create table tbl_album ( K_ID int identity (1,1), K_ALBUM varchar (150), K_DATE date, ); INSERT INTO tbl_KpopBG (K_NAME, K_COMPANY, K_DEBUT, K_SALES) VALUES ('BTS', 'BIGHIT ENTERTAINMENT', 'June 12, 2013', 9030000), ('SEVENTEEN', 'PLEDIS ENTERTAINMENT', 'May 26,2015', 2720000), ('NCT 127', 'SM ENTERTAINMENT', 'July 6, 2016', 1560000), ('STRAY KIDS', 'JYP ENTERTAINMENT', 'March 25, 2018' , 942800), ('TXT', 'BIGHIT ENTERTAINMENT', 'March 4, 2019', 921600); SELECT * FROM tbl_KpopBG; INSERT INTO tbl_album (K_ALBUM, K_DATE) VALUES ('Love Yourself', 'October 23, 2017'), ('Pretty U', 'June 20, 2016'), ('Kick It', 'November 2, 2018'), ('Levanter', 'October 20, 2018'), ('The Dream Chapter', 'August 9, 2018'); SELECT * FROM tbl_album; SELECT K_COMPANY, AVG(K_SALES) as Sales FROM tbl_KpopBG GROUP BY K_COMPANY go SELECT K_NAME, AVG(K_SALES) as Sales FROM tbl_KpopBG GROUP BY K_NAME HAVING (AVG(K_SALES)> 1560000) go SELECT tbl_KpopBG. K_NAME, tbl_album. K_ALBUM FROM tbl_KpopBG INNER JOIN tbl_album ON tbl_KpopBG. K_ID = tbl_album. K_ID go