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 ); INSERT INTO BOOKS VALUES (1, 'Popular Author'), (2, 'Less popular author'); INSERT INTO POSSESSION VALUES (1, '2021-05-06'), (2, '2021-07-08'); SELECT COUNT(AUTHOR), 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 FETCH FIRST 1 ROWS WITH TIES;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear