SELECT all columns in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from the table named employees.

SQL

SELECT [1] FROM employees;

Drag options to blanks, or click blank then click option'

A*

Ball

Ccolumns

Deverything

Attempts:

3 left

💡 Hint

Common Mistakes

Writing 'all' instead of '*'

Using 'columns' which is not valid syntax

Using * selects all columns from the table.

2fill in blank

medium

Complete the code to select all columns from the table named products.

SQL

SELECT [1] FROM products;

Drag options to blanks, or click blank then click option'

Aall

B*

Ceverything

Dfields

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'all' or 'fields' which are not valid SQL keywords here.

The * symbol selects all columns in SQL.

3fill in blank

hard

Fix the error in the code to select all columns from the table orders.

SQL

SELECT [1] FROM orders;

Drag options to blanks, or click blank then click option'

Aall

Border

C*

Dcolumns

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'all' or 'columns' which cause syntax errors.

The correct way to select all columns is using *.

4fill in blank

hard

Fill both blanks to select all columns from the table customers and order the results by the customer_id column.

SQL

SELECT [1] FROM customers ORDER BY [2];

Drag options to blanks, or click blank then click option'

A*

Bcustomer_id

Cid

Dall

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'all' instead of '*'

Ordering by a wrong column name like 'id'

* selects all columns, and customer_id is the column to order by.

5fill in blank

hard

Fill all three blanks to select all columns from the table sales where the region is 'East' and order the results by the sale_date column.

SQL

SELECT [1] FROM sales WHERE [2] = 'East' ORDER BY [3];

Drag options to blanks, or click blank then click option'

A*

Bregion

Csale_date

Ddate

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'date' instead of 'sale_date' for ordering.

Using 'all' instead of '*' for selecting columns.

* selects all columns, region is the filter column, and sale_date is the column to order by.