Skip to content

Latest commit

 

History

History
23 lines (19 loc) · 475 Bytes

File metadata and controls

23 lines (19 loc) · 475 Bytes

sql-data-analysis

Description:

This project contains a collection of SQL queries used to analyze a database. It includes queries for data retrieval, filtering, aggregation, joins, and reporting.

Tables:

  • Customers
  • Orders
  • Products

Technologies used:

  • SQL (MySQL / PostgreSQL / SQLite)
  • DBMS (MySQL Workbench / pgAdmin)

Queries:

  1. Basic Queries
    • SELECT, WHERE, ORDER BY
  2. Joins
    • INNER JOIN
    • LEFT JOIN
  3. Subqueries
  4. Group By & Having