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

Question 16

Staff who live in Woodridge

Unsolved Easy Lecture

Instruction

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

Table: staff_list

staff_list

id	name	address	zip code	phone	city	country	sid
1	Mike Hillyer	23 Workhaven Lane		14033335568	Lethbridge	Canada	1
2	Jon Stephens	1411 Lillydale Drive		6172235589	Woodridge	Australia	2

 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

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine Postgres

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

5:00

Timer

Your results

Run your query to preview results here.

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

Browse Topic Set

Question	Level	Company	FTPR
#228. Analyzing Sequential Purchase Behavior	Hard	microsoft
#227. Aggregate Sale Amounts per Customer	Hard	microsoft
#226. Customer Lifetime Value (CLV) and Segmentation	Hard	microsoft
#225. Customer Behavior Analysis	Hard	microsoft
#224. Categories with High Average Product Price	Medium	microsoft
#223. Cumulative Total Sales by Day	Hard	microsoft
#222. Product Sales Ranking Within Categories	Hard	microsoft
#221. Customers With More Than 5 Products in a Single Transaction	Hard	microsoft
#220. Most Expensive Product in Each Category	Hard	microsoft
#219. Inactive Customers in the New Year of 2024	Medium	microsoft
#218. Total Amount Spent by Each Customer	Medium	microsoft
#217. Most engaged customers	Hard	roblox	10%
#210. Issuer and merchant report	Easy	visa	100%
#200. Last week's absent students	Medium	snap	67%
#175. Employees' email account	Easy	amazon	14%
#152. Salary analysis	Easy	dropbox	20%
#126. Top 3 restaurants	Hard	uber	10%
#111. Second most popular product	Medium	amazon	16%
#92. Acceptance rate first week of 2021	Easy	spotify	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%