Explore table sizes
Let's start by exploring five related tables:
stackoverflow: questions asked on Stack Overflow with certain tagscompany: information on companies related to tags instackoverflowtag_company: linksstackoverflowtocompanytag_type: type categories applied to tags instackoverflowfortune500: information on top US companies
Count the number of columns in a table by selecting a few rows and manually counting the columns in the result.
Which table has the most rows?
This exercise is part of the course
Exploratory Data Analysis in SQL
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise