#494 Designing Author and Book Tables

Companies:

Wildberries

Themes:

SQLJoinsPractice

Create the tables author (id, name, age) and book (id, title, author_id).

What constraints can be applied to the table data? If necessary, create a junction table for a many-to-many relationship.

Also write queries that return an author by book when the author's age is less than 40. Use a JOIN.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.