Question: User ( UId , Username, Password, Profile, Brief, Joindate) Post ( Code , Title, Details, PublishDate, views, status, type) Comment ( UId, PostCode , Description,

User (UId, Username, Password, Profile, Brief, Joindate)

Post (Code, Title, Details, PublishDate, views, status, type)

Comment (UId, PostCode, Description, commentDate)

Write the corresponding SQL queries for the below questions

  1. For each post code, list the total number of comments it has.
  2. Find the post titles having more than 500 views.
  3. Find the post titles with no comments.
  4. Find the highest number of views and average number of views of posts.
  5. List the username and title of post and description of the comment he added.

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!

Q:

Old MathJax webview Faster please Consider the following relations. The primary keys are underlined while the foreign keys are in italic. User (UId, Username, Password, Profile, Brief, Joindate) Post...

Q:

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. User (UId, Username, Password, Profile, Brief, Joindate) Post...

Q:

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. User (UId, Username, Password, Profile, Brief, Joindate) Post...

Q:

I need the solution of all these questions . Problem 3: Normalization (20 pts) Consider the following table and functional dependencies: PASSENGER FLIGHTNO COMPANY DEPARTURE ARRIVAL COMPANY PASSENGER...

Q:

Consider the following relations. The primary keys are underlined while the foreign keys are in italic. User (Uld, Username, Password, Profile, Brief, Joindate) Post (Code, Title, Details,...

Q:

Can someone please help with this Linux script? So i figured out my last assignment, but our teacher wants us to modify this script using the following perameters. 1. Add a function to validate the...

Q:

We have a TikTok database which contains the following five tables with their relationships. USER: Store information about users, including UID, Username, Age, Country, FollowersCount. VIDEO: Store...

Q:

WEIGHTAGE: 20% Assignment is to experience networked rpm based OS, advanced storage, bash scripting, MAC security, remote access, remote file sharing, etc., The assignment requires two VMs, it can be...

Q:

You have received a new batch of distinguished users; their basic information is located in newusers.txt on Schoology. This file contains a colon-separated entry for each user: the username, the uid,...

Q:

User (uid, uname, age, city, country) Reads (uid, aid, t2r, datetime) Article (aid, title, length, category) where keys are underlined category: takes values such as Cryptocurrency, Regulations,...

Q:

Suppose Mexico wants to protect its domestic auto-mobile industry from U.S. and Japanese competition. How will a tariff on imported cars help it to accomplish this task? How does the tariff affect...

Q:

Research and answer the following components: NoSQL : Explain and provide examples. What are the benefits, disadvantages, and challenges? Compare and contrast 2-3 NoSQL options. OLAP : Explain. Big...

Q:

what is the highest cybercrime a ) investment fund b ) identify theft c ) cyberstalking d ) money laundering

Q:

O Which of the following is the incorrect statement? Multiple Choice The difference in the total benefit and the total cost is maximized at the optimal level of Q. dB(Q)/dQ dC(Q)/dQ at the level of...

Q:

6. Go to www.capellauniversity.edu, the Web site for Capella Universitya university that offers online courses. Click on Online Learning on the left side of the page. View the short course demo and...

Q:

4. Go to www.mzinga.com. Mzinga provides software solutions for learning. Click on Technology. Then click on Mzinga Social Learning Suite. What learning solutions are provided by the Social Learning...

Q:

2. The Interactive Patient is a realistic interactive computer simulation of a patients visit to a physicians office. The Interactive Patient is a Web-based training program used to train medical...