HappyLearning

                                                              T-SQL Server-GROUP BY Clause What is GROUP BY ? In SQL Group BY is a function used to query results from the groups of rows with the help of Aggregate functions. It helps to generate quick reports and insights from data base. Aggregate functions: * Count * Min * Max * Sum * Avg Ex: Assuming we have different category vegetables in basket. Tomato, Potato, Brinjal all mixed in same bucket. with the help of GROUP BY and AGGREGATE functions we will retrive data from database to analyze how many vegetables and varieties in basket.

                                                                                       Danny's Dinner SQL Challenge - 1 Data set link : https://8weeksqlchallenge.com/getting-started/ 3 key datasets for this case study: Entity Relationship Diagram Case Study Questions Each of the following case study questions can be answered using a single SQL statement: create database Dannys_Dinner CREATE TABLE sales (   "customer_id" VARCHAR(1),   "order_date" DATE,   "product_id" INTEGER ); INSERT INTO sales   ("customer_id", "order_date", "product_id") VALUES   ('A', '2021-01-01', '1'),   ('A', '2021-01-01', '2'),   ('A', '2021-01-07', '2'),   ('A', '2021-01-10', '3'),   ('A', '2021-01-11', '3'), ...

  👩‍🏫 If you are looking Power BI related documents then this post is for you. 🎈 In this 2024 DATA ANALYTICS is highly Boomed but don't think you can become a DATA ANALYST with in 2hrs or 2 days. So just deep dive into 1 DAX formula per day and do practice then you will be familiar end of 1 month. 🎈Data Analysis Expressions (DAX) 🎈Data Analysis Expressions (DAX) is a powerful formula language that is at the core of Microsoft Power BI and other Microsoft products like Excel and SQL Server Analysis Services. 🎈DAX is designed for creating custom calculations, aggregations, and data transformations within these tools. 🎈This chapter introduces you to the fundamental concepts of DAX and lays the foundation for your journey into mastering its essentials. 🎈It means that it is a type of formula or expressions that are used for the analysis and calculations of data. 🎈You need to understand its basic syntax. 🎈DAX formulas are written in a similar way to Excel formulas, using functio...

                                                                                  GEMINI VS CHATGPT  SQL Challenge-GEMINI VS CHATGPT  TABLES Models Capabilities Benchmarks SQL SCHEMA    -- Table to store information about different models CREATE TABLE Models (     ModelID INT PRIMARY KEY,     ModelName VARCHAR(255) NOT NULL ); -- Table to store information about various capabilities CREATE TABLE Capabilities (     CapabilityID INT PRIMARY KEY,     CapabilityName VARCHAR(255) NOT NULL ); -- Table to store benchmark scores for different models and capabilities CREATE TABLE Benchmarks (     BenchmarkID INT PRIMARY KEY,     ModelID INT,     Capabil...

                                                                        92.7 BIG FM Radio Network Digits n Data -  https://nitish2162001.github.io/webpa/#sql-schema   SQL CHALLENGE -  Digits n Data  -  https://nitish2162001.github.io/webpa/#sql-schema SQL CHALLENGE - 92.7 BIG FM radio network Tables names: Stations Hosts Shows Partnerships ShowPartnerships Awards OnlinePresence Schema: SQL Schema                            CREATE TABLE Stations (                                 StationID INT PRIMARY KEY,                             ...