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

thadguidry profile image

How to connect and query multiple databases with a single REST API

Thad Guidry -

thinkthroo profile image

Biome.js, a toolchain to format and lint your web project

thinkThroo -

thinkthroo profile image

Component decorator in TypeDoc

thinkThroo -

ngtduc693 profile image

AI Bot: Intelligent Financial Query Assistant Powered by PostgreSQL and Ollama

Duc Nguyen Thanh -