Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started