Question: 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,

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 (Code, Title, Details, PublishDate, views, status, type) Comment (UId, PostCode, Description, commentDate) Write the corresponding SQL queries for the below questions

1. Write a query to retrieve the Username and Profile of all Users ordered alphabetically.

2. Write a query to find the titles of post having status pending and published after 1/1/2022.

3. List the username of user which contains a.

4. Find the username of user who comments on post having code 110 and 120.

5. Write a query to Find the title of all posts and description and date of its comments.

6. List the username and title of post and description of the comment he added.

7. Find the highest number of views and average number of views of posts. 8. For each post code, list the total number of comments it has.

9. Find the post titles having more than 500 views.

10. Find the post titles with no comments.

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!

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, H Num, Type, View,...

Database Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, HNum, Type,...

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, HNum, Type, View,...

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...

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,...

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...

I need answer as soon as possible please. task is related to SQL. I'm waiting for your response. thank you so much in advance. Assignment #2: SQL 1 Goal Learn about and use various SQL constructs....

6 1 Goal Learn about and use various SQL constructs. 2 Task Create at least 2 views Create at least 2 materialized views Create the following SQL queries: Using CASE expression - at least 2 queries...

Refer to the Smith Valley Snow Park Lodge expansion project in S21-2. Requirement 1. Calculate the ROR.

Grain Co-op, LLC, and Hearty Cereals, Inc., discuss the terms of a contract for periodic deliveries of corn. Grain faxes Hearty a memo on Grain's letterhead that summarizes the points on which they...

Equity Method Year Subsequent to Acquisition LO 2 LO 5 Continue the situation in Exercise 46 and assume that during 2020 Sales Company earned 190000 and declared and paid a 50000 dividend Required A...

On June Sandhill Co. Ltd. borrows $ 76,000 from Acme Bank on a 6-month, $ 76,000, 6% note. The note matures on Your answer is correct Prepare the entry on June 1. (Credit account tities are...

7. A group of managers (N25) participated in the problem-solving module of a leadership development program two weeks ago. The module consisted of two days in which the group focused on the correct...

9. What metrics might be useful for evaluating the effectiveness of a companys training function? Discuss and rate their importance.

10. What acceptable methods can be used to show the costs and benefits of training without collecting statistics and conducting analyses? Explain these methods and their strengths and weaknesses...