10-usefulqueries.md

<<< Back - Next >>>

Querying to summarize your data

Using the SQLITE REPL, let's see what the nypl_items table looks like. To load the database, first confirm that you are in the database-practice directory. Start the Sqlite program:

sqlite3

Then, type this text to open our database:

.open file:nypldb.db

1. How many records are in the table?

SELECT COUNT(*) FROM nypl_items;

2. What do the records look like?

SELECT * FROM nypl_items LIMIT 3;

3. How many different languages do you have items in?

SELECT DISTINCT language FROM nypl_items;

<<< Back - Next >>>