Supposed
we have a table Staffs containing the first and last name of all staffs in USTH.
Write a query to return find the official email of each person, given that the domain is @usth.edu.vn and the
mail is of the following format: last_name.first_name@usth.edu.vn

Question

Supposed
we have a table Staffs containing the first and last name of all staffs in USTH.
Write a query to return find the official email of each person,  given that the domain is @usth.edu.vn and the
mail is of the following format: last_name.first_name@usth.edu.vn

Answer

C.  SELECT first_name , last_name ,distinct(first_name)
AS Official_mail FROM Staffs;

Answer

B.  All of these are correct

Answer

D.  SELECT first_name , last_name, concat('@usth.edu.vn',
first_name) AS Official_mail FROM Staffs;

Answer

A.  SELECT first_name ,
last_name, concat(last_name, '. ', first_name, '@usth.edu.vn ') AS
Official_mail FROM Staffs;

Crowdly

Supposed we have a table Staffs containing the first and last name of all staffs...

Want instant access to all verified answers on moodle.usth.edu.vn?