In our e-commerce database we have a users table with the columns id, username, password, first_name and last_name.
WRITE SQL QUERY
Maxwell Newberry7,676 Points
You are given the column names, you just need to write a query that matches the name.
- The key word retrieves data from the database, which tells us
SELECTis the correct statement we need to use.
- The challenge outlines that we only want to select the first and last name from the rows, so for the select fields we want to specify only
last_namedelimiter by a comma.
- We're of course retrieve data
userstable, and we want to specific that we only want data
wig_lady'. Therefore, our query will finish to become:
SELECT `first_name`, `last_name` FROM `users` WHERE `username` = 'wig_lady';