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.

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