Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Imagine you have a table called employees that contains the columns employee_id, first_name, last_name, department, and email.
Write a SQL query to select all columns for every employee listed in the employees table.
| employee_id | first_name | last_name | department | |
|---|---|---|---|---|
| 1 | Emily | Johnson | Marketing | emily.johnson@example.com |
| 2 | Arjun | Kumar | IT |
| arjun.kumar@example.com |
| 3 | Sofia | Martinez | HR | sofia.martinez@example.com |
Imagine you have a table called employees that contains the columns employee_id, first_name, last_name, department, and email.
Write a SQL query to select all columns for every employee listed in the employees table.
| employee_id | first_name | last_name | department | |
|---|---|---|---|---|
| 1 | Emily | Johnson | Marketing | emily.johnson@example.com |
| 2 | Arjun | Kumar | IT | arjun.kumar@example.com |
| 3 | Sofia | Martinez | HR | sofia.martinez@example.com |