contestada

Question In an existing company database, the customers table contains the following columns: CustomerId, FirstName, LastName, Company, Address, City, State, Country, PostalCode, Phone, Fax, Email, and SupportRepId.

Respuesta :

lhmarianateixeira

Using the knowledge in computational language in SQL it is possible to write a code that  existing company database, the customers table contains.

Writting the code in SQL:

SELECT FirstName,

      LastName,

      HireDate,

      (STRFTIME('%Y', 'now') - STRFTIME('%Y', HireDate))

         - (STRFTIME('%m-%d', 'now') < STRFTIME('%m-%d', HireDate))

         AS YearsWorked

FROM Employees

WHERE YearsWorked >= 15

ORDER BY LastName ASC

See more about SQL at brainly.com/question/13068613

#SPJ1

Ver imagen lhmarianateixeira

Otras preguntas