Question: 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

  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).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!