12. Inspecting a specific user record

Sandra and Linh were sitting and reading SQL manuals when Gessica entered the room. "Girls, I need your help! Some user has sent us 5 emails, he claims that he purchased a subscription, but is no longer able to log in. I checked with the agency, they said that indeed a user tried to log in with no success many times, user’s id is 2404. I need your help figuring out what’s wrong with this user.".

"Let’s look at his record first, maybe it’s just a typo in the email." – said Linh as she was reading about the WHERE keyword.

⚠ IMPORTANT: this is the first exercise, let me show you around real quick. To solve each exercise we’ll work with the actual database of Bindle. To query this database use the SQL Editor tab or Playground ☝ – type in any SQL query you want there.

⚠ Once you’re ready with the query and you think you got the answer – submit it in this field below 👇 For example if email f foo

And now comes the first exercise: What’s the email of a user with id 2404?

⚠ Type SQL queries in the SQL Editor ☝ to find the answer to this exercise. Do your research in the SQL Editor and then submit numeric or text answer via this form. ⚠

Hint

You need to write a query which could be interpreted like “From all the records in the users table give me one which has id equals to 2404”.

Solution

SELECT email
FROM users
WHERE
  id = 2404

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons and exercises (you’re looking at one atm). They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type in your query here. You might want to start by listing all records: SELECT * FROM users
LIMIT 500
Loading chart... ⏳