Initializing SQL database...
Back to Questions
Join books with authors #200
hardShow book_title with their author_name. Complex joins with multiple tables, self-joins, or joins combined with aggregation and filtering. Plan your join strategy carefully and consider the relationships between tables.
Practice with:
Database Schema
books
books information
idnameref_id
authors
authors information
idname
Expected Output
Click "Show" to see what the correct output should look like.Tip: Try solving it yourself first for better learning!
SQL Editor
Loading...
Press Ctrl+Enter to run query • Start typing for autocomplete