/*8. Write a query in SQL to display the full name (first and last name), and salary for all employees who does not earn
 any commission.*/
SELECT first_name ||' '||last_name AS Full_Name, salary  
 FROM  employees  
  WHERE commission_pct IS NULL;