16. Staff who live in Woodridge

easy

Instruction
  • Write a query to return the names of the staff who live in the city of 'Woodridge'

Table: staff_list

 col_name | col_type
----------+----------
 id       | integer
 name     | text
 address  | text
 zip code | text
 phone    | text
 city     | text
 country  | text
 sid      | smallint

Sample results

     name
--------------
 Jon Stephens

Solution postgres

SELECT name 
FROM staff_list 
WHERE city = 'Woodridge';
    

Explanation

This query is asking the database to retrieve the names of all employees who live in the city of Woodridge. The database is looking in a table called "staff_list" which should contain a list of all employees and their corresponding information such as name, address, and city. The "WHERE" clause is filtering the results to only include employees who live in Woodridge. The output of this query will be a list of employee names who live in Woodridge.

Expected results



More SELECT, WHERE, AND, OR, ORDER BY, LIMIT questions

ID Title Level FTPR
217 Most engaged customers roblox hard
10%
210 Issuer and merchant report visa easy
100%
200 Last week's absent students snap medium
67%
175 Employees' email account amazon easy
14%
152 Salary analysis dropbox easy
20%
126 Top 3 restaurants uber hard
10%
111 Second most popular product amazon medium
16%
92 Acceptance rate first week of 2021 spotify easy
14%
17 GROUCHO WILLIAMS’ actor_id easy
57%
4 Staff without a profile image easy
66%
3 Top 5 shortest movies easy
49%
2 Top 3 movie categories by sales easy
42%
1 Top store for movie sales easy
24%