Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Retrieve a list of posts, sorted in descending order of datetime _ created so that the latest post appears at the top. If two posts

Retrieve a list of posts, sorted in descending order of datetime_created so that the latest post appears at the top. If two posts have the same datetime_created, sort them based on the post_id in descending order, with higher post IDs appearing at the top. (i. e. descending order).
Tables Schema as Below:
post
columnName dataType
id int
username varchar(24)
post_title varchar (72)
post_description text
datetime_created datetime
number_of_likes int
photo blob
Input

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Relational Database Design

Authors: Candace C. Fleming, Barbara Von Halle

1st Edition

0201114348, 978-0201114348

More Books

Students also viewed these Databases questions

Question

In Administrative Tools, choose DHCP. LO.1

Answered: 1 week ago