Site icon Doc Sity

Whats the Name of The User Who Has the Most Negative Votes MySQL Questions

Whats the Name of The User Who Has the Most Negative Votes MySQL Questions

Description

 

1. Show titles and scores for posts whose title contains the word “hash” and has a score above 10. Show highest scoring first

2. What’s the title of the lowest-scoring post that has an accepted answer? (Write a query that gives a single answer.)

3.What’s the name of the user who has the most negative votes (i.e., upvotes – downvotes) and is not id=-1 ? (Write a query that gives a single answer.)

4.What’s the name of the earliest user (by creation date) who has written no posts? (Write a query that gives a single answer.  HINT: use a LEFT JOIN.)

5.List the postid and title of all posts that have at least one comment that mentions the word “homework”. Don’t allow any repeats, and eliminate posts with an empty title.

6.List the creation date of the postlink for posts with user having display name silent1mezzo limited to 10 results.  

Explanation & Answer:
6 Questions
User generated content is uploaded by users for the purposes of learning and should be used following our honor code & terms of service.

Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Exit mobile version