Search⌘ K
Home
Courses
The Art of PostgreSQL

Solution Review: Managing the Output in SQL

Explore methods to manage and optimize SQL query output by applying sorting, pagination, and aggregate functions. Understand how to join tables, use group by and having clauses to filter and control the data returned by your queries for efficient data presentation.

We'll cover the following...

Solution

The solution for the challenge is given below. Click the “Run” button in the following widget and see the output of the code.

/***************************************************/
/*****              The query to               *****/
/*****      retrieve the albums along with     *****/
/*****      the size using business logic      *****/
/***************************************************/
  select album.title as album, SUM(bytes) as size
    from track
         join album using(albumid)
group by album.title 
  having SUM(bytes) < 2000000;
/***************************************************/
Retrieve the albums with their size

Explanation

Here is the explanation of the solution to the ...