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.

Last Submission postgres

Expected results



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

ID Title Level FTPR
228 Analyzing Sequential Purchase Behavior microsoft hard -
227 Aggregate Sale Amounts per Customer microsoft hard -
226 Customer Lifetime Value (CLV) and Segmentation microsoft hard -
225 Customer Behavior Analysis microsoft hard -
224 Categories with High Average Product Price microsoft medium -
223 Cumulative Total Sales by Day microsoft hard -
222 Product Sales Ranking Within Categories microsoft hard -
221 Customers With More Than 5 Products in a Single Transaction microsoft hard -
220 Most Expensive Product in Each Category microsoft hard -
219 Inactive Customers in the New Year of 2024 microsoft medium -
218 Total Amount Spent by Each Customer microsoft medium -
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%