Using WHERE conditions

Easy

You've got a bit of a situation here. Your trusty computer has just gone on a little break. You need to reach out to the IT department, pronto! But, there's a twist: their contact info is in the employees table, and it's up to you to find it using SQL.

Find the first names, last names, and email addresses of everyone in the IT department.

Example Output:

first_name	last_name	email
Arjun	Kumar	arjun.kumar@example.com
Jack	Taylor	jack.taylor@example.com
Mason	Martinez

Using WHERE conditions

SQL+1

Easy

Find the first names, last names, and email addresses of everyone in the IT department.

Example Output:

first_name	last_name	email
Arjun	Kumar	arjun.kumar@example.com
Jack	Taylor	jack.taylor@example.com
Mason	Martinez

Modules

Using WHERE conditions

Example Output:

Using WHERE conditions

Example Output: