Challenge: Generate a Summarized Books Table
The library staff requests a simplified version of the books
table to generate a quick report. This table should only include the following columns:
title
author
published_year
Swipe to start coding
Your task is to write a query to create a new table named books_summary
, which will contain only these three columns from the books
table, along with all the data from the respective columns.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 1.72
Challenge: Generate a Summarized Books Table
Swipe to show menu
The library staff requests a simplified version of the books
table to generate a quick report. This table should only include the following columns:
title
author
published_year
Swipe to start coding
Your task is to write a query to create a new table named books_summary
, which will contain only these three columns from the books
table, along with all the data from the respective columns.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 1.72single