Aggregate Data

p {margin: 0; padding: 0;} .ft00{font-size:18px;font-family:NimbusRomanRegular;color:#000000;} Aggregate Data Before   We   go   to   Aggregate   data,   we   need   to   know   about   what   is   aggregate   data   and disaggregate   data.   Aggregate   data   combines   and   summarizes   information,   whereas disaggregate data separate aggregated data into separate points or pieces of information. To do Aggregate data in our data we can use Group by function  GROUP BY command used to summarize the value and group it by specific criteria. We need to use AGGREGATE function to summarize numbers. “AS” is alias to rename column name For example: SELECT gender, COUNT (id) AS “# of Customer” FROM customer WHERE city = ‘Jakarta’ GROUP BY gender