Challenge: Top-N Factbook Entries
Explore how to craft SQL queries in PostgreSQL to retrieve the top-N records from the factbook table starting from a given date. This lesson enhances your ability to filter and sort data effectively, using real-world financial trade and share data.
We'll cover the following...
We'll cover the following...
Problem statement
Write a query to retrieve top-N records from the factbook table where the start date would be 2010-02-04.
Here’s what the data in the factbook table looks like:
year date