SQL query

Question

The details of the customer whose name starts either with letter C or P
Your output should contain 6 column customer _address_id, customer _id,first_name,address, phone,email

Answer 1

Select customer_address_id, customer_id, first_name, address, phone, email
From Customers
Where first_name like 'C%' or first_name like 'P%'

https://www.w3schools.com/mysql/mysql_like.asp