Question
Consider the following tables for the SongsInfo database: Song (Id, title, Number of sales, Singer_Id, ReleasedDate); Singer (Id, Name, Country, Age); Primary keys are underlined.
Consider the following tables for the SongsInfo database: Song (Id, title, Number of sales, Singer_Id, ReleasedDate); Singer (Id, Name, Country, Age);
Primary keys are underlined. There are foreign key constraints on Song.Singer_id referencing Singer. Answer the following questions: 1. Display all data of the singers having their name ending with letter n. [10 points] 2. Display singers who are greater than 28 years old. [5 points] 3. Display data of all singers from the oldest to the youngest. [10 points] 4. Display the data of singers from USA. [5 points] 5. Display the songs released in 2017. [5 points] 6. Display the singers who are from England or whose name contains h. [5 points] 7. Display the songs (title, Number of sales) for Kendrick Lamar [10 points] 8. Display the number of sales for the song 'Castle on the Hill'. [10 points] 9. Display the total number of songs, and name it as The number of songs. [10 points] 10. Display all songs based on the number of sales descending order. [5 points] 11. Change the number of sales of the song 'Castle on the Hill' to become 5120110. [10 points] 12. Remove the song having Id = 4. [5 points] 13. Insert the following records in the corresponding table: [10 points]
Song (9, 'Locked Out of Heaven', 47168124, 5, '2012-10-01') Song (10, 'Too Much to Ask', 68265320, 3, '2017-09-15')
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