The conversation between human and AI assistant.
[|Human|] Construct a valid SQL query for the following scenario.
[|AI|] The SQL query to retrieve the customer's last name, phone number, and email from the customer table would be:

SELECT last_name, phone_number, email FROM customer;
[|Human|] 
Construct a valid SQL query for the following scenario.