Scribd
Upload
6 views1 page

SQL Queries for Product and Customer Analysis

The document contains several SQL queries that select, group, filter, and order data from various database tables like Products, Customers, Orders, and Suppliers. The queries count, sum, and average numeric fields, group results by categories, filter based on conditions, and order outcomes in ascending or descending sequences.

Uploaded by

Mahfujur Rahman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views1 page

SQL Queries for Product and Customer Analysis

The document contains several SQL queries that select, group, filter, and order data from various database tables like Products, Customers, Orders, and Suppliers. The queries count, sum, and average numeric fields, group results by categories, filter based on conditions, and order outcomes in ascending or descending sequences.

Uploaded by

Mahfujur Rahman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SELECT PRODUCTNAME, COUNT (*) AS NUM_ROWS, SUM(PRICE) AS TOTAL_SALES, AVG (PRICE) AS

AVG_SALES FROM PRODUCTS GROUP BY PRODUCTNAME HAVING AVG_SALES >10 ORDER BY PRICE ASC

SELECT PRODUCTNAME, COUNT (*) AS NUM_ROWS, SUM(PRICE) AS TOTAL_SALES, AVG (PRICE) AS


AVG_SALES FROM PRODUCTS GROUP BY PRODUCTNAME HAVING AVG_SALES >10

WERE FORMULA

SELECT * FROM [Products] WHERE UNIT >10

DECENDING ORDER

SELECT COUNTRY, COUNT (*) AS NUMBEROFCUSTOMERS FROM [CUSTOMERS]

GROUP BY COUNTRY HAVING NUMBEROFCUSTOMERS>10 ORDER BY NUMBEROFCUSTOMERS DESC

ACENDING ORDER

SELECT COUNTRY, COUNT (*) AS NUMBEROFCUSTOMERS FROM [CUSTOMERS]

GROUP BY COUNTRY HAVING NUMBEROFCUSTOMERS>10 ORDER BY NUMBEROFCUSTOMERS ASC

SELECT COUNTRY, COUNT (*) AS CUSTOMERNUMBER FROM CUSTOMERS GROUP BY COUNTRY HAVING
CUSTOMERNUMBER >10;

GROUP BY COUNTRY

SELECT COUNTRY, COUNT (*) AS CUSTOMERNUMBER FROM CUSTOMERS GROUP BY COUNTRY

SELECT CustomerName FROM Customers where Country= 'Mexico'

Quiz

SELECT contactname FROM Customers where Country= 'Germany'

Select ProductID, ProductName, Price from Products where ProductName='Maxilaku'

SELECT orderid,productid,quantity from orderdetails where quantity>30

SELECT * from products where productid=51

SELECT productname,price FROM products where price >20;

SELECT * FROM [Suppliers] where country='USA'

You might also like