Question

write and run sql statement display first name, last name, and age of employees who are less than 50 years old

Answer 1

Answer:

See explanation

Explanation:

The table definition is not given. However, I'll assume the following.

Table Name: Employees

Table Columns: FIRSTNAME, LASTNAME, AGE, DEPARTMENT

The sql statement is as follows:

SELECT FIRSTNAME, LASTNAME, AGE FROM EMPLOYEES WHERE AGE < 50

Analysis of the above

SELECT ---- This signifies that the query is to retrieve data

FIRSTNAME, LASTNAME, AGE  --- This signifies the columns to fetch data

FROM EMPLOYEES  ---- this signifies the table name

WHERE AGE < 50 --- This signifies the condition of the query