Grokking SQL for Tech Interviews

0% completed

​
28. Books and Authors

Problem

Table: Books

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| book_id       | int     |
| title         | varchar |
| genre         | varchar |
+---------------+---------+
book_id is the primary key for this table.
This table contains information about the books in a library.

Table: Authors

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| author_id     | int     |
| book_id       | int     |
| author_name   | varchar |
+---------------+---------+

.....

.....

.....

Like the course? Get enrolled and start learning!