Write Sql Solution F Return Userids Female Users Never Posted Jokes Gave Comments Jokes G Q37027469

Write a SQL solution for

f). Return the userids of those female users who never postedany jokes but gave some comments to some jokes.

g). Return the userids of those male users who only posted jokesbut never gave any comments.

h). Write an UPDATE stmt to ban the users who neither posted anyjokes nor gave any comments.

i). Write a DELETE stmt to delete all the users who posted atleast 10 empty jokes – those jokes that have no description.

j). Return the userids of the users who have posted jokes aswell as some comments to some jokes.


Solution


Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.