Identify the SELECT statements that execute successfully. SELECT first name, last name job id , salary12 AS "Yearly Sal" FROM employees; SELECT first name, last name ,job id, salary12 yearly sal FROM employees; SELECT first name, , last name,job id, salary AS yearly sal FROM employees; SELECT first n ame+last name AS name,job Id, salary*12 yearly sal FROM employees;

Question

Identify the SELECT statements that execute successfully. SELECT first name, last name job id , salary12 AS "Yearly Sal" FROM employees; SELECT first name, last name ,job id, salary12 yearly sal FROM employees; SELECT first name, , last name,job id, salary AS yearly sal FROM employees; SELECT first n ame+last name AS name,job Id, salary*12 yearly sal FROM employees;

Answer 1

The SELECT statement that executes successfully is:```sqlSELECT first_name, last_name, job_id, salary/12 AS "Yearly Sal"FROM employees;```Explanation:- The correct syntax for selecting multiple columns in SQL is to separate them with commas.- The `AS` keyword is used to give an alias to the selected columns, and it should be followed by the alias name enclosed in quotes.- The division operator `/` is used instead of the backslash `\\` for division in SQL.- The `FROM` clause specifies the table from which to retrieve the data.

Soru

Çözüm

Cevap