DEV Community

AsadullohRuziev
AsadullohRuziev

Posted on • Edited on

PostgreSQL unit-10

#database #postgres #sql #typescript

Aggregate Functions

Fake data mockaroo.com/
Image description

Image description

\i C:/Users/asadu/Downloads/car.sql;
Enter fullscreen mode Exit fullscreen mode

Image description

Image description

SELECT MAX(price) FROM car;
Enter fullscreen mode Exit fullscreen mode 
SELECT MIN(price) FROM car;
Enter fullscreen mode Exit fullscreen mode 
SELECT AVG(price) FROM car;
Enter fullscreen mode Exit fullscreen mode 
 SELECT ROUND(AVG(price)) FROM car;
Enter fullscreen mode Exit fullscreen mode

Image description

-----------------------------------------

Image description

Image description

Image description

Top comments (0)

Read next

mspilari profile image

Fullstack app: Deploying the Fullstack Application on Render with Docker

Matheus Bernardes Spilari -

mnkow profile image

From Monolith to Monorepo: A Next.js Migration Story

Michal Kowalkowski -

softheartengineer profile image

How does shareReplay() works in RxJs/angular?

Soft Heart Engineer -

thesohailjafri profile image

5 Quick And Easy MongoDB Optimizations (part 1)

Sohail @chakraframer.com -