LEGO_SET_ANALYSIS

LEGO Set Dataset SQL Queries

Overview

This repository contains a set of SQL queries for analyzing a LEGO Set dataset. The dataset includes information about various LEGO sets, such as set ID, name, year of release, theme, category, and more.

Dataset Description

The dataset is structured with the following columns:

• Set_ID
• Name
• Year
• Theme
• Theme_Group
• Subtheme
• Category
• Packaging
• Num_Instructions
• Availability
• Pieces
• Minifigures
• Owned
• Rating
• USD_MSRP
• Total_Quantity
• Current_Price

SQL Queries

1. Select all columns from the dataset:
2. Filter data for a specific year:
3. Count the number of rows in the dataset:
4. Find the unique themes in the dataset:
5. Calculate the average rating:
6. Find the highest USD_MSRP:
7. Show the top 10 highest-rated sets
8. Count the number of sets in each theme:
9. Find the average USD_MSRP for each year:
10. List the sets with more than 500 pieces:
11. Calculate the total number of pieces for each theme:
12. Find the sets with the highest number of minifigures:
13. Count the number of sets in each category for a specific year:
14. Calculate the average number of minifigures for each theme group:

15. ---

16. ---

17. ---

18. ---

19. ---

20. ---

21. ---

22. ---

23. ---

24. ---

25. ---

26. ---

27. ---

28. ---

29. ---

30. ---

31. ---

32. ---

33. ---

34. ---

35. ---

36. ---

37. ---

38. ---

39. ---

40. ---

Instructions for Use

1. Dataset Loading:

Ensure that you have the dataset file (Lego_set_data.csv) available. Modify the file name in the queries to match the actual file name. Executing Queries:

Copy and paste the SQL queries into your preferred SQL environment (e.g., MySQL, SQLite, PostgreSQL). Execute the queries to retrieve specific information or insights from the dataset. Analysis and Interpretation:

Use the results of the queries to analyze various aspects of the LEGO Set dataset. Explore trends, distributions, and relationships between different columns.