Fundamentals of Data Analysis Count numbers of published books

31. Count numbers of published books

“We need to make sure users who purchased have enough books to read, otherwise they’ll cancel their subscriptions!” said Gessica, “How many books do we have in Bindle’s library?”

So far we’ve been working only with the users table –it’s time to move on and learn about the new table – books (in the end, Bindle is a subscription service for reading books).

Let’s start simple and answer the questions: “How many books do we have in total?” (read: how many book records are in the books table).

“well worth the money”
Sign up and check out 36 free lessons and exercises.

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons and exercises (you’re looking at one atm). They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type in your query here. You might want to start by listing all records: SELECT * FROM books
Loading chart... ⏳