How do I create an SQL view (also called a view) in Microsoft SQL Server?

This help article from Microsoft describes the procedure in detail. The required SQL schema (layout of the table / column names) is displayed when authorizing the SQL account in sync.blue®:

One phone number per number type (business, private, mobile) is currently supported.