Click Insert in the top menu, then select Pivot table from the drop-down menu to open the Create pivot table window. Confirm the range of data you selected.

Jack Wallen shows you how easy it is to create a MongoDB database and collection using the Compass GUI.

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.