Question

1. Write a query in SQL to list the following information of the artists in movie industry. Limit this information to only 5 artists. Sort the information by age descending order.

         Full name : first name and last name separated by space

         Age: Current age

         Address: State that he resides

         Contact number: Phone number

This is from an artist table, where first_name, last_name, contact_no, address, birth_date are the fields in the table. Birth date in the table is given like this: "1985-06-19" (yyyy,mm,dd).

Answer 1

If you have any doubts, please give me comment...

SELECT first_name || ' ' || last_name AS "Full name", DATEDIFF(yy,CONVERT(DATETIME, birth_date),GETDATE()) AS Age, address, contact_no

FROM artist

ORDER BY Age DESC

LIMIT 5;