Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
28. Books and Authors
On this page

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!

On this page