Câu 98: AWS Certified Data Engineer - Associate DEA-C01

A company has a data warehouse that contains a table that is named Sales. The company stores the table in Amazon Redshift. The table includes a column that is named city_name. The company wants to query the table to find all rows that have a city_name that starts with "San" or "El".Which SQL query will meet this requirement?

1. A. Select * from Sales where city_name ~ ‘$(San|El)*’;
2. B. Select * from Sales where city_name ~ ‘^(San|El)*’; — đáp án hiện tại
3. C. Select * from Sales where city_name ~’$(San&El)*’;
4. D. Select * from Sales where city_name ~ ‘^(San&El)*’;