Question: Write SQL queries for the database and questions below. 1. Find the number of users who are also artist. 2. Print the id of artists

Write SQL queries for the database and questions below.

Write SQL queries for the database and questions below. 1. Find the

1. Find the number of users who are also artist.

2. Print the id of artists who doesnt have a bio.

3. Find all the people (pid, first_name, last_name) who are interested in the genre classical.

4. Find the number of users who are paying for Premium service using VISA card.

5. Find the full name(s), first and last, of the user who skipped listening to the song starts with `Ut`.

6. For each content item whose title contains the word ipsum, find the content ID and total number of likes for each.

7. Find the ids of artist(s) whose bio contains the strings Grammys Award and 2017 (the artist received a Grammy Award and has an event in 2017).

8. Find all zipcode(s) of people who have a public playlist with at least 2 classical songs.

Duration --pid firstname lastname Playlist People interest User Artist title Type Content Free Premiumm exp date rating Song Video Ads image Playlist Create People User Artist Follower Follow Followee since Content Free Premium Watch User AND Artist OVERLAP Song Video User AND Artist COVER People Free AND Premium COVER User Ads

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!