SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table POSSESSION ( BOOK_ID INT, TAKING_DATE DATE ); create table BOOKS ( ID INT, AUTHOR VARCHAR ); SELECT AUTHOR FROM POSSESSION INNER JOIN BOOKS ON BOOK_ID = BOOKS.ID WHERE TAKING_DATE > (CURRENT_DATE - INTERVAL '1 year') GROUP BY AUTHOR ORDER BY COUNT(AUTHOR) DESC LIMIT 1;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear