Soru
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;
Çözüm
4.5126 Voting
Nesrin
Elit · 8 yıl öğretmeniUzman doğrulaması
Cevap
The SELECT statement that executes successfully is:<br /><br />```sql<br />SELECT first_name, last_name, job_id, salary/12 AS "Yearly Sal"<br />FROM employees;<br />```<br /><br />Explanation:<br />- The correct syntax for selecting multiple columns in SQL is to separate them with commas.<br />- 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.<br />- The division operator `/` is used instead of the backslash `\\` for division in SQL.<br />- The `FROM` clause specifies the table from which to retrieve the data.
Derecelendirmek için tıklayın: