PostgreSQL | SELECT | SUM | COUNT | ORDER BY | HAVING | Using basic SQL functions for Data Analysis

Описание: Working with SQL requires constant practice and solving simple analysis questions to better hone your skills using each function.

Database: dvdrental
Tool: PostreSQL (PgAdmin)
Questions:
8. Return the customer IDs of customers who have spent at least $110 with the staff member who has an ID of 2.

I used PostreSQL (PgAdmin) to analyze the "dvdrental" database. The database consisted of various tables giving information about a DVD rental business. I used basic SQL functions to answer different questions to analyze the data. Each question was answered in an iterative process showing a step-by-step approach to arriving at the final query required to produce the answer needed from the question.

#project #analytics #thankyou #powerbi #sales #data #dataanalysis #power #training #comment #data #analytics #powerbi #excel #dashboard #dataanalytics #dataanalysis #datavisualisation #kpi #tableau #mssql #sql #microsoft #database #azuresql #business #postgresql #customer #customerdata