Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

Basic SELECT statement

Theory

Manager

Report a typo

Write a query that selects and assigns aliases to the specified details of an employee. The query should output the following information with the given aliases:

  • First name as first_name with the value 'John'

  • Second name as second_name with the value 'Jeffrey'

  • Salary as salary with the value 20000

  • Department as department with the value 'IT'

Write an SQL statement





___

Create a free account to access the full topic