Introduction to columns

In the SELECT section of the tutorial, you learned how to choose the data you want to see from a table. You can either:

• Use to select all columns, or
• List specific column names to select only the ones you need.

This helps you control the width of your result — deciding how many and which columns appear in your table.

In the Filtering section, you learned how to use the WHERE clause to decide which rows to include, based on specific conditions. This allows you to control the height of the table — meaning how many and which rows are shown.

With these two tools combined, you now have the ability to define both the rows and columns (height and width) from your original dataset that you want to include in your results.

The functions you’ve learned so far are by no means an exhaustive list, but should give you a good starting point for working in SQL on your own. You’ll most likely use many of these going forward, potentially in combination with other more advanced functions.

🔧 What’s Next: Creating New Columns

In the Creating columns section of the tutorial, you’ll work with something new: creating new content to be included in your table.

You’ll learn how to:

• Create your own new columns to be included in the table — typically based on changing existing data into a new form, or by performing calculations based on the existing data.