Support the project! The site exists thanks to the community. If the help covers the expenses - the platform remains free.Support →
SQL code copied to buffer
Task 57:

Customers by Phone Prefix

Retrieve customers whose phone numbers start with 972. Print a table with the fields:
- CustomerID - Unique identifier for each customer
- FirstName, LastName - Customer's first and last name
- Phone - Customer's phone number
sorted by the first field.

Use SQL Server 2022 syntax to write your answer. Descriptions of tables are provided in the right pane.

Write your request in the field below and click the "Check it!" button.
Get hint
Copy code Clear editor

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.