Am trying to make a subquery, where the first query finds every entity with a specific first name, and then a subquery that limits said entities to a specific last name.

Here are the relevant table:

Create Table Customer ( Customer_id int NOT NULL AUTO_INCREMENT, FirstName VARCHAR(50), LastName VARCHAR(50), MailingAddress Varchar(50), ShippingAddress VARCHAR(50), PhoneNumber Varchar (50), CreditCardLimit VARCHAR(50), DiscountPossible boolean, DiscountAmount int, CONSTRAINT Customer_id_PK PRIMARY KEY (Customer_id) );

I'm not too sure on the syntax on how to write that query and subquery.