Instruction Write a SQL query to return this staff's first name and last name. Picture field contains the link that points to a staff's profile image. There is only one staff who doesn't have a profile picture. Use colname IS NULL to identify data that are missing.

Prev Discuss

Question 4

Staff without a profile image

Unsolved Easy Lecture

Premium Access

Unlock this premium interview question.

230+ interview questions
Official solutions
SQL, Python, and R tracks

***********

***** * *** ***** ** ****** **** *****'* ***** **** *** **** ****.
******* ***** ******** *** **** **** ****** ** * *****'* ******* *****.
***** ** **** *** ***** *** *****'* **** * ******* *******.
*** ******* ** **** ** ******** **** **** *** *******.

Table: staff

  ***_****   | ***_****
-------------+--------------------------
 *****_**    | *******
 *****_****  | ****
 ****_****   | ****
 *******_**  | ********
 *****       | ****
 *****_**    | ********
 ******      | *******
 ********    | ****
 *******     | ********* *******

Sample results

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

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%
#16. Staff who live in Woodridge	Easy		65%
#3. Top 5 shortest movies	Easy		49%
#2. Top 3 movie categories by sales	Easy		42%
#1. Top store for movie sales	Easy		24%