# SQL Function ## Definition(s) ### Context: [[Nexus - Google Analytics Certificate Course#5.3 Google Analytics - 5 Analyze - Module 3 - Aggregate Data for Analysis Aggregate Data for Analysis|Google Analytics Certificate]] #### Sub-context: [[SQL keywords]] >[! Definition] >These are built in operations that do things in SQL. ## Examples ```sql SELECT Warehouse.warehouse_id, CONCAT(Warehouse.state, ': ', Warehouse.warehouse_alias) AS warehouse_name, COUNT(Orders.order_id) AS number_of_orders FROM your-project.warehouse_orders.warehouse AS Warehouse LEFT JOIN your-project.warehouse_orders.orders AS Orders ON Orders.warehouse_id = Warehouse.warehouse_id GROUP BY Warehouse.warehouse_id, warehouse_name HAVING COUNT(Orders.order_id) > 0 ``` ## Related ### Data aggregation functions [[COUNT]] [[CASE]] [[HAVING]] [[IF]] [[AVG]] ## Resources ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/)