Video upload date:  · Duration: PT1H46M27S  · Language: EN

Consider the following SQL query: SELECT a databricks video

data-analyst video for consider the following SQL query: SELECT a . employee_id as employee_identifier , b . employee_id as sales_ver_employee_identifier , a .

This is a dedicated watch page for a single video.

Full Certification Question

Consider the following SQL query: SELECT a . employee_id as employee_identifier , b . employee_id as sales_ver_employee_identifier , a . employee_name as employee_name , b . role as sales_ver_role_name FROM employees a ( _____ ) join sales_employees b ON ( a . employee_id = b . employee_id ); What type of SQL JOIN is represented in the above query to generate the below result? | employee_identifier | sales_ver_employee_identifier | employee_name | sales_ver_role_name | |---------------------|-------------------------------|----------------|----------------------| | 1 | 1 | Tom | Sales Rep | | 2 | NULL | Luke | NULL | | 3 | 3 | Sarah | Sales Director |