My first SQL course in Skillshare.

Designed a library management database where books are borrowed.

 

Table creation:

 

 

Data insertion:

 

Tables:

 

Data Manipulation:

 

This query selects the fname column from borrower table, book_title from book table, genre from book table, status from borrower table and return_date from library management table.

 

 

This query counts how many books are written by the author with the author ID of 3. These books should be Silent Voice and Oyasumi Punpun.