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
- 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
Get step-by-step solutions from verified subject matter experts
