SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table tbl_ya ( YoungAdult_BookId int identity(1,1) NOT NULL primary key, Book_Title varchar(150) NOT NULL, Book_Author varchar(150), Book_Pages int, Published_Date datetime, Publishing_House varchar(150), Book_Ratings decimal(12,4), ); INSERT INTO tbl_ya (Book_Title, Book_Author, Book_Pages, Published_Date, Publishing_House, Book_Ratings) VALUES('Thirteen Reasons Why', 'Jay Asher', '288', '2007-10-18 00:00:00', 'Penguin Young Readers', '4.7'), ('The Fault in Our Star', 'John Green', '313', '2012-01-10 00:00:00', 'Dutton Book', '4.2'), ('Youve Reached Sam', 'Dustin Thao', '304', '2021-11-09 00:00:00', 'St. Martins Publishing Group', '4.1'), ('All the Bright Places', 'Jennifer Niven', '388', '2015-01-06 00:00:00', 'Knopf Publishing Group', '4.1'), ('One of Us is Lying', 'Karen M. McManus', '268', '2017-05-29 00:00:00', 'Delacorte Press', '4.0'), ('They Both Die in the End', 'Silvera', '384', '2017-09-05 00:00:00', 'HarperTeen', '4.0'), ('Everything Everything', 'Nicola Yoon', '310', '2015-09-01 00:00:00', 'Delacorte Books', '4.0'), ('Red Queen', 'Victoria Aveyard', '388', '2015-02-10 00:00:00', 'HarperTeen', '4.0'), ('We Were Liars', 'E. Lockhart', '256', '2014-05-13 00:00:00', 'Delacorte Press', '3.8'), ('Paper Town', 'John Green', '305', '2008-10-16 00:00:00', 'Dutton Books', '3.8'); SELECT * FROM tbl_ya go SELECT Book_Title, avg(Book_Ratings) as Book_Ratings FROM tbl_ya GROUP BY Book_Title go SELECT Book_Title, avg(Book_Ratings) as Book_Ratings FROM tbl_ya GROUP BY Book_Title HAVING avg(Book_Ratings)>4 go
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear