Simple Select — Solution & ExplanationProblems / Simple Select / EditorialApproachThis is the most fundamental SQL operation: choosing which columns to return.

SELECT only the three required columns: first_name, last_name, major.

No filtering, sorting, or aggregation is needed.

The key lesson is that SELECT * returns every column, but specifying column names gives you only what you need — a best practice for performance and clarity.Hints

In SQL, list the column names you want after SELECT, separated by commas.

You do not need a WHERE clause — just pick the right columns.

In PySpark, use .select() to choose columns.

Solve Simple Select yourself →