Why this is used

SELECT * is how you explore a new table. It shows you everything at once. Pair it with LIMIT right away so you don't accidentally load thousands of rows. These two almost always go together when you're getting familiar with unfamiliar data.