SQLPad
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 NULLto identify data that are missing.
Table: staff
col_name | col_type -------------+-------------------------- staff_id | integer first_name | text last_name | text address_id | smallint email | text store_id | smallint active | boolean username | text picture | character varying
Sample results
first_name | last_name ------------+----------- Jon | Snow
Expected results
Solution postgres
SELECT first_name, last_name
FROM staff
WHERE picture IS NULL;
Explanation
This query is selecting the first and last names of all staff members from a table called "staff." However, it is only selecting those staff members whose "picture" field is null, meaning they do not have a picture associated with their profile.
Copied
Your results