mam if it is possible to provide dml and ddl commands for all tables you have used to write the above 15 query,plese provide it,It takes a lot of time to write ddl and dml commands for all tables
with cte as( SELECT Books.Book_id, Title, Borrower_Date FROM Books LEFT JOIN Borrowed ON Books.Book_id = Borrowed.Book_id where Borrower_Date BETWEEN ADDDATE(DATE(NOW()),-181) AND DATE(NOW()) ),cte1 as( select Books.Title,cte.Title as title1 FROM Books LEFT JOIN cte ON Books.Book_id=cte.Book_id ) select Title FROM cte1 where title1 is null;
mam if it is possible to provide dml and ddl commands for all tables you have used to write the above 15 query,plese provide it,It takes a lot of time to write ddl and dml commands for all tables
Do visit this repository, to go through all the commands coeverd in this video: github.com/SamairaRoy25/SQL-Interview-Questions
Beauty with brain. Good set of questions for SQL interview
Thank you for your kind words. We hope this video helped you gauge the critical SQL queries.
with cte as(
SELECT Books.Book_id, Title, Borrower_Date FROM Books LEFT JOIN Borrowed ON Books.Book_id = Borrowed.Book_id
where Borrower_Date BETWEEN ADDDATE(DATE(NOW()),-181) AND DATE(NOW())
),cte1 as(
select Books.Title,cte.Title as title1 FROM Books LEFT JOIN cte ON Books.Book_id=cte.Book_id
)
select Title FROM cte1 where title1 is null;