10-usefulqueries.md

<<< Back - Next >>>

Querying to summarize your data

Usibng the REPL, let's see what the nypl_items table looks like:

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 >>>