<<< Back - Next >>>

Querying to summarize your data

Let's see what the nypl_items table looks like:

1. How many records are in the table?

    SELECT COUNT(*) FROM nypl_items;  

   1. What do the records look like?

    SELECT * FROM nypl_items LIMIT 3;

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

    SELECT DISTINCT language FROM nypl_items;

<<< Back - Next >>>