MySQL PIVOT Quiz: Test Your SQL Skills Today!

Progress

True / False

MySQL supports the PIVOT operator natively.

True False

MySQL does not have a native PIVOT operator. Instead, users often use conditional aggregation or dynamic SQL to achieve similar results.

True / False

To simulate a PIVOT in MySQL, you can use the CASE statement within an aggregate function.

True False

MySQL users can simulate a PIVOT table by using CASE statements within aggregate functions like SUM() or COUNT() to manually transform rows into columns.

True / False

You can use GROUP_CONCAT() to create a PIVOT-like output in MySQL.

True False

GROUP_CONCAT() is used to concatenate values from multiple rows into a single string, but it doesn't perform PIVOT operations. It is not a substitute for PIVOT functionality.

True / False

MySQL’s GROUP BY clause can be used in conjunction with conditional aggregation to achieve a PIVOT-like result.

True False

By using GROUP BY along with conditional aggregation (using CASE or IF), you can simulate PIVOT functionality to rearrange data from rows into columns.

True / False

The UNION operator in MySQL can be used to simulate a PIVOT by stacking rows vertically.

True False

UNION is used to combine result sets vertically, not to transform row data into columns. It does not simulate PIVOT operations.

True / False

You can use dynamic SQL in MySQL to create a PIVOT table with varying numbers of columns.

True False

Dynamic SQL allows for creating queries on-the-fly with varying columns, which can be used to generate PIVOT-like tables where the number of columns may change.

True / False

MySQL’s INSERT INTO ... SELECT statement can be used to prepare data for a PIVOT table by first creating a staging table.

True False

By using INSERT INTO ... SELECT, you can prepare and transform data in a staging table before performing PIVOT operations through other queries.

True / False

Using the CROSS JOIN clause in MySQL is a recommended method for achieving PIVOT operations.

True False

CROSS JOIN produces a Cartesian product and is not typically used for PIVOT operations. Instead, CROSS JOIN might be used for generating combinations of data.

True / False

MySQL’s PREPARE and EXECUTE statements can be used to create a dynamic PIVOT query where column names are generated at runtime.

True False

PREPARE and EXECUTE allow for dynamic SQL execution, which can be used to create PIVOT queries with columns generated dynamically based on runtime data.

Q10

True / False

MySQL Workbench provides a built-in PIVOT feature for transforming data in a graphical interface.

True False

MySQL Workbench does not provide a built-in PIVOT feature. Users need to manually write SQL queries to simulate PIVOT functionality or use other tools or methods.

Q11

Single Choice

Which MySQL function can be used in combination with CASE to simulate a PIVOT table?

CONCAT SUM COUNTMAX

The SUM function is often used with CASE statements to simulate a PIVOT table by aggregating data based on conditions

Q12

Single Choice

In a basic PIVOT operation, what is the role of the GROUP BY clause in MySQL?

It sorts the result It combines multiple rows into one. It divides the result set into groups.It filters the result set

The GROUP BY clause is used to group rows that have the same values in specified columns, which is essential for aggregating data in a PIVOT operation.

Q13

Single Choice

Which keyword is typically used to conditionally aggregate data in a MySQL PIVOT-like query?

IF WHERE CASESELECT

The CASE statement is used to conditionally aggregate data in MySQL, simulating the PIVOT operation by creating columns based on specific conditions.

Q14

Single Choice

Which SQL query would you use to PIVOT this data to show SalesAmount by Product and Quarter?

SQL Code

Given the following table Sales:
Product	Quarter	SalesAmount
A	 Q1	 1000
A	 Q2	 1500
B	 Q1	 2000
B	 Q2	 2500

SELECT Product, SUM(CASE WHEN Quarter = 'Q1' THEN SalesAmount ELSE 0 END) AS Q1, SUM(CASE WHEN Quarter = 'Q2' THEN SalesAmount ELSE 0 END) AS Q2 FROM Sales GROUP BY Product; SELECT Product, SUM(CASE WHEN SalesAmount = 'Q1' THEN Quarter ELSE 0 END) AS Q1, SUM(CASE WHEN SalesAmount = 'Q2' THEN Quarter ELSE 0 END) AS Q2 FROM Sales GROUP BY Product; SELECT Product, CASE WHEN Quarter = 'Q1' THEN SUM(SalesAmount) ELSE 0 END AS Q1, CASE WHEN Quarter = 'Q2' THEN SUM(SalesAmount) ELSE 0 END AS Q2 FROM Sales GROUP BY Product;SELECT Product, SUM(IF(Quarter = 'Q1', SalesAmount, 0)) AS Q1, SUM(IF(Quarter = 'Q2', SalesAmount, 0)) AS Q2 FROM Sales GROUP BY Quarter;

This query correctly uses CASE and SUM to simulate a PIVOT table, showing SalesAmount for each Product by Quarter.

Q15

Single Choice

Which of the following queries can be used to simulate a PIVOT operation on a Product table with Category and Price columns, to get the total price for each category?

SELECT Category, SUM(CASE WHEN Category = 'Electronics' THEN Price ELSE 0 END) AS Electronics, SUM(CASE WHEN Category = 'Furniture' THEN Price ELSE 0 END) AS Furniture FROM Product GROUP BY Category; SELECT Category, SUM(CASE WHEN Category = 'Electronics' THEN Price ELSE 0 END) AS Electronics, SUM(CASE WHEN Category = 'Furniture' THEN Price ELSE 0 END) AS Furniture FROM Product GROUP BY Category, Price; SELECT SUM(CASE WHEN Category = 'Electronics' THEN Price ELSE 0 END) AS Electronics, SUM(CASE WHEN Category = 'Furniture' THEN Price ELSE 0 END) AS Furniture FROM Product;SELECT Category, SUM(Price) FROM Product GROUP BY Category;

This query groups by Category using SUM and CASE to aggregate Price for each category, which is a common PIVOT simulation technique.

Q16

Single Choice

In the context of a PIVOT-like operation in MySQL, which statement about using UNION ALL is correct?

UNION ALL is used to combine results of multiple SELECT statements without removing duplicates. UNION ALL is used to group rows that have the same value in specified columns. UNION ALL is used to filter records based on a specified condition.UNION ALL is used to join tables on a common key.

UNION ALL can be used in a PIVOT-like operation to combine results from multiple queries without filtering out duplicate rows, allowing all results to be included.

Q17

Single Choice

Write a SQL query to PIVOT this data to show the total Amount for each Status by Customer.

SQL Code

You have the following Orders table:

OrderID	Customer	Status	Amount
1	Alice	Pending	100
2	Bob	Shipped	200
3	Alice	Shipped	150
4	Bob	Pending	250

SELECT Customer, SUM(CASE WHEN Status = 'Pending' THEN Amount ELSE 0 END) AS Pending, SUM(CASE WHEN Status = 'Shipped' THEN Amount ELSE 0 END) AS Shipped FROM Orders GROUP BY Customer; SELECT Status, SUM(CASE WHEN Customer = 'Alice' THEN Amount ELSE 0 END) AS Alice, SUM(CASE WHEN Customer = 'Bob' THEN Amount ELSE 0 END) AS Bob FROM Orders GROUP BY Status; SELECT Customer, CASE WHEN Status = 'Pending' THEN SUM(Amount) ELSE 0 END AS Pending, CASE WHEN Status = 'Shipped' THEN SUM(Amount) ELSE 0 END AS Shipped FROM Orders;SELECT Customer, SUM(IF(Status = 'Pending', Amount, 0)) AS Pending, SUM(IF(Status = 'Shipped', Amount, 0)) AS Shipped FROM Orders; GROUP BY Status;

This query uses CASE and SUM to calculate the total Amount for each Status by Customer, simulating a PIVOT operation.

Q18

Single Choice

If you encounter performance issues while executing a complex PIVOT operation in MySQL, which indexing strategy could help optimize the query?

Indexing the pivoted columns Indexing the GROUP BY columns Indexing the SELECT columnsIndexing the HAVING clause

Indexing the GROUP BY columns can improve the performance of PIVOT operations, as it speeds up the process of grouping

Q19

Single Choice

In a MySQL PIVOT simulation, what happens if the GROUP BY column contains NULL values?

NULL values are ignored in the output. NULL values are treated as a separate group. The query will fail with an error.NULL values are replaced by the COALESCE function.

In MySQL, when using GROUP BY, any NULL values in the grouped column are treated as a separate group, and the PIVOT operation will include this group in the results.

Q20

Single Choice

Consider a MySQL query that pivots a table sales based on the region and month columns. The query uses a CASE statement to conditionally sum the sales data. If the query performs slowly on a large dataset, which of the following optimization techniques could improve performance?

Use a UNION ALL to split the query into multiple parts. Create an index on the month and region columns. Use SELECT DISTINCT instead of GROUP BY.Replace CASE with IFNULL.

Indexing the columns used in the GROUP BY and CASE statements, such as month and region, can significantly improve query performance by reducing the time it takes to aggregate and pivot the data.

Q21

Multiple Choice

Which SQL query uses PIVOT to transform rows into columns, aggregating sales data by product and quarter?

SQL Code

SELECT product_name,
SUM(CASE WHEN quarter = 'Q1' THEN sales ELSE 0 END) AS Q1_sales,
SUM(CASE WHEN quarter = 'Q2' THEN sales ELSE 0 END) AS Q2_sales,
SUM(CASE WHEN quarter = 'Q3' THEN sales ELSE 0 END) AS Q3_sales,
SUM(CASE WHEN quarter = 'Q4' THEN sales ELSE 0 END) AS Q4_sales
FROM sales_data
GROUP BY product_name;

SELECT product_name, SUM(CASE WHEN quarter = 'Q1' THEN sales ELSE 0 END) AS Q1_sales, SUM(CASE WHEN quarter = 'Q2' THEN sales ELSE 0 END) AS Q2_sales, SUM(CASE WHEN quarter = 'Q3' THEN sales ELSE 0 END) AS Q3_sales, SUM(CASE WHEN quarter = 'Q4' THEN sales ELSE 0 END) AS Q4_sales FROM sales_data GROUP BY product_name; SELECT product_name, quarter, sales FROM sales_data GROUP BY product_name, quarter; SELECT product_name, CASE WHEN quarter = 'Q1' THEN sales END AS Q1_sales, CASE WHEN quarter = 'Q2' THEN sales END AS Q2_sales, CASE WHEN quarter = 'Q3' THEN sales END AS Q3_sales, CASE WHEN quarter = 'Q4' THEN sales END AS Q4_sales FROM sales_data;SELECT product_name, SUM(CASE WHEN quarter = 'Q1' THEN sales END) AS Q1_sales, SUM(CASE WHEN quarter = 'Q2' THEN sales END) AS Q2_sales, SUM(CASE WHEN quarter = 'Q3' THEN sales END) AS Q3_sales, SUM(CASE WHEN quarter = 'Q4' THEN sales END) AS Q4_sales FROM sales_data GROUP BY product_name, quarter;

This query uses conditional aggregation to pivot sales data by quarter, transforming rows into columns for each quarter's sales.

Q22

Multiple Choice

Identify the SQL query that uses PIVOT to summarize employee attendance data, showing the total days attended per month.

SQL Code

SELECT employee_name,
SUM(CASE WHEN month = 'January' THEN days_attended ELSE 0 END) AS Jan_days,
SUM(CASE WHEN month = 'February' THEN days_attended ELSE 0 END) AS Feb_days,
SUM(CASE WHEN month = 'March' THEN days_attended ELSE 0 END) AS Mar_days
FROM attendance_data
GROUP BY employee_name;

SELECT employee_name, SUM(CASE WHEN month = 'January' THEN days_attended ELSE 0 END) AS Jan_days, SUM(CASE WHEN month = 'February' THEN days_attended ELSE 0 END) AS Feb_days, SUM(CASE WHEN month = 'March' THEN days_attended ELSE 0 END) AS Mar_days FROM attendance_data GROUP BY employee_name; SELECT employee_name, month, days_attended FROM attendance_data GROUP BY employee_name, month; SELECT employee_name, CASE WHEN month = 'January' THEN days_attended END AS Jan_days, CASE WHEN month = 'February' THEN days_attended END AS Feb_days, CASE WHEN month = 'March' THEN days_attended END AS Mar_days FROM attendance_data;SELECT employee_name, SUM(CASE WHEN month = 'January' THEN days_attended END) AS Jan_days, SUM(CASE WHEN month = 'February' THEN days_attended END) AS Feb_days, SUM(CASE WHEN month = 'March' THEN days_attended END) AS Mar_days FROM attendance_data GROUP BY employee_name, month;

This query pivots the attendance data by month, aggregating the total days attended for each employee across different months.

Q23

Multiple Choice

Which SQL query uses PIVOT to show the total sales for each product across different regions?

SQL Code

SELECT product_name,
SUM(CASE WHEN region = 'North' THEN sales ELSE 0 END) AS North_sales,
SUM(CASE WHEN region = 'South' THEN sales ELSE 0 END) AS South_sales,
SUM(CASE WHEN region = 'East' THEN sales ELSE 0 END) AS East_sales,
SUM(CASE WHEN region = 'West' THEN sales ELSE 0 END) AS West_sales
FROM sales_data
GROUP BY product_name;

SELECT product_name, SUM(CASE WHEN region = 'North' THEN sales ELSE 0 END) AS North_sales, SUM(CASE WHEN region = 'South' THEN sales ELSE 0 END) AS South_sales, SUM(CASE WHEN region = 'East' THEN sales ELSE 0 END) AS East_sales, SUM(CASE WHEN region = 'West' THEN sales ELSE 0 END) AS West_sales FROM sales_data GROUP BY product_name; SELECT product_name, region, sales FROM sales_data GROUP BY product_name, region; SELECT product_name, CASE WHEN region = 'North' THEN sales END AS North_sales, CASE WHEN region = 'South' THEN sales END AS South_sales, CASE WHEN region = 'East' THEN sales END AS East_sales, CASE WHEN region = 'West' THEN sales END AS West_sales FROM sales_data;SELECT product_name, SUM(CASE WHEN region = 'North' THEN sales END) AS North_sales, SUM(CASE WHEN region = 'South' THEN sales END) AS South_sales, SUM(CASE WHEN region = 'East' THEN sales END) AS East_sales, SUM(CASE WHEN region = 'West' THEN sales END) AS West_sales FROM sales_data GROUP BY product_name, region;

This query pivots the sales data by region, showing total sales for each product in different regions.

Q24

Multiple Choice

Determine the SQL query that uses PIVOT to display the total number of orders for each product across different years.

SQL Code

SELECT product_name,
SUM(CASE WHEN year = 2021 THEN order_count ELSE 0 END) AS Orders_2021,
SUM(CASE WHEN year = 2022 THEN order_count ELSE 0 END) AS Orders_2022,
SUM(CASE WHEN year = 2023 THEN order_count ELSE 0 END) AS Orders_2023
FROM order_data
GROUP BY product_name;

SELECT product_name, SUM(CASE WHEN year = 2021 THEN order_count ELSE 0 END) AS Orders_2021, SUM(CASE WHEN year = 2022 THEN order_count ELSE 0 END) AS Orders_2022, SUM(CASE WHEN year = 2023 THEN order_count ELSE 0 END) AS Orders_2023 FROM order_data GROUP BY product_name; SELECT product_name, year, order_count FROM order_data GROUP BY product_name, year; SELECT product_name, CASE WHEN year = 2021 THEN order_count END AS Orders_2021, CASE WHEN year = 2022 THEN order_count END AS Orders_2022, CASE WHEN year = 2023 THEN order_count END AS Orders_2023 FROM order_data;SELECT product_name, SUM(CASE WHEN year = 2021 THEN order_count END) AS Orders_2021, SUM(CASE WHEN year = 2022 THEN order_count END) AS Orders_2022, SUM(CASE WHEN year = 2023 THEN order_count END) AS Orders_2023 FROM order_data GROUP BY product_name, year;

This query pivots the order data by year, showing the total number of orders for each product across different years.

Q25

Multiple Choice

Which SQL query uses PIVOT to aggregate sales data, showing the total revenue generated by each salesperson across different months?

SQL Code

SELECT salesperson,
SUM(CASE WHEN month = 'January' THEN revenue ELSE 0 END) AS Jan_revenue,
SUM(CASE WHEN month = 'February' THEN revenue ELSE 0 END) AS Feb_revenue,
SUM(CASE WHEN month = 'March' THEN revenue ELSE 0 END) AS Mar_revenue
FROM sales_data
GROUP BY salesperson;

SELECT salesperson, SUM(CASE WHEN month = 'January' THEN revenue ELSE 0 END) AS Jan_revenue, SUM(CASE WHEN month = 'February' THEN revenue ELSE 0 END) AS Feb_revenue, SUM(CASE WHEN month = 'March' THEN revenue ELSE 0 END) AS Mar_revenue FROM sales_data GROUP BY salesperson; SELECT salesperson, month, revenue FROM sales_data GROUP BY salesperson, month; SELECT salesperson, CASE WHEN month = 'January' THEN revenue END AS Jan_revenue, CASE WHEN month = 'February' THEN revenue END AS Feb_revenue, CASE WHEN month = 'March' THEN revenue END AS Mar_revenue FROM sales_data;SELECT salesperson, SUM(CASE WHEN month = 'January' THEN revenue END) AS Jan_revenue, SUM(CASE WHEN month = 'February' THEN revenue END) AS Feb_revenue, SUM(CASE WHEN month = 'March' THEN revenue END) AS Mar_revenue FROM sales_data GROUP BY salesperson, month;

This query pivots the sales data by month, showing the total revenue generated by each salesperson across different months.

Q26

Multiple Choice

Which SQL query uses PIVOT to display the total hours worked by employees in different departments across various projects?

SQL Code

SELECT department,
SUM(CASE WHEN project = 'Project A' THEN hours_worked ELSE 0 END) AS ProjectA_hours,
SUM(CASE WHEN project = 'Project B' THEN hours_worked ELSE 0 END) AS ProjectB_hours,
SUM(CASE WHEN project = 'Project C' THEN hours_worked ELSE 0 END) AS ProjectC_hours
FROM work_data
GROUP BY department;

SELECT department, SUM(CASE WHEN project = 'Project A' THEN hours_worked ELSE 0 END) AS ProjectA_hours, SUM(CASE WHEN project = 'Project B' THEN hours_worked ELSE 0 END) AS ProjectB_hours, SUM(CASE WHEN project = 'Project C' THEN hours_worked ELSE 0 END) AS ProjectC_hours FROM work_data GROUP BY department; SELECT department, project, hours_worked FROM work_data GROUP BY department, project; SELECT department, CASE WHEN project = 'Project A' THEN hours_worked END AS ProjectA_hours, CASE WHEN project = 'Project B' THEN hours_worked END AS ProjectB_hours, CASE WHEN project = 'Project C' THEN hours_worked END AS ProjectC_hours FROM work_data;SELECT department, SUM(CASE WHEN project = 'Project A' THEN hours_worked END) AS ProjectA_hours, SUM(CASE WHEN project = 'Project B' THEN hours_worked END) AS ProjectB_hours, SUM(CASE WHEN project = 'Project C' THEN hours_worked END) AS ProjectC_hours FROM work_data GROUP BY department, project;

This query pivots the work data by project, showing the total hours worked by employees in different departments across various projects.

Q27

Multiple Choice

Identify the SQL query that uses PIVOT to show the total number of units sold per product across different store locations.

SQL Code

SELECT product_name,
SUM(CASE WHEN location = 'Store A' THEN units_sold ELSE 0 END) AS StoreA_units,
SUM(CASE WHEN location = 'Store B' THEN units_sold ELSE 0 END) AS StoreB_units,
SUM(CASE WHEN location = 'Store C' THEN units_sold ELSE 0 END) AS StoreC_units
FROM sales_data
GROUP BY product_name;

SELECT product_name, SUM(CASE WHEN location = 'Store A' THEN units_sold ELSE 0 END) AS StoreA_units, SUM(CASE WHEN location = 'Store B' THEN units_sold ELSE 0 END) AS StoreB_units, SUM(CASE WHEN location = 'Store C' THEN units_sold ELSE 0 END) AS StoreC_units FROM sales_data GROUP BY product_name; SELECT product_name, location, units_sold FROM sales_data GROUP BY product_name, location; SELECT product_name, CASE WHEN location = 'Store A' THEN units_sold END AS StoreA_units, CASE WHEN location = 'Store B' THEN units_sold END AS StoreB_units, CASE WHEN location = 'Store C' THEN units_sold END AS StoreC_units FROM sales_data;SELECT product_name, SUM(CASE WHEN location = 'Store A' THEN units_sold END) AS StoreA_units, SUM(CASE WHEN location = 'Store B' THEN units_sold END) AS StoreB_units, SUM(CASE WHEN location = 'Store C' THEN units_sold END) AS StoreC_units FROM sales_data GROUP BY product_name, location;

This query pivots the sales data by store location, showing the total number of units sold for each product across different stores.

Q28

Multiple Choice

Which SQL query uses PIVOT to aggregate the number of hours logged by employees on different tasks?

SQL Code

SELECT employee_name,
SUM(CASE WHEN task = 'Task 1' THEN hours_logged ELSE 0 END) AS Task1_hours,
SUM(CASE WHEN task = 'Task 2' THEN hours_logged ELSE 0 END) AS Task2_hours,
SUM(CASE WHEN task = 'Task 3' THEN hours_logged ELSE 0 END) AS Task3_hours
FROM time_log
GROUP BY employee_name;

SELECT employee_name, SUM(CASE WHEN task = 'Task 1' THEN hours_logged ELSE 0 END) AS Task1_hours, SUM(CASE WHEN task = 'Task 2' THEN hours_logged ELSE 0 END) AS Task2_hours, SUM(CASE WHEN task = 'Task 3' THEN hours_logged ELSE 0 END) AS Task3_hours FROM time_log GROUP BY employee_name; SELECT employee_name, task, hours_logged FROM time_log GROUP BY employee_name, task; SELECT employee_name, CASE WHEN task = 'Task 1' THEN hours_logged END AS Task1_hours, CASE WHEN task = 'Task 2' THEN hours_logged END AS Task2_hours, CASE WHEN task = 'Task 3' THEN hours_logged END AS Task3_hours FROM time_log;SELECT employee_name, SUM(CASE WHEN task = 'Task 1' THEN hours_logged END) AS Task1_hours, SUM(CASE WHEN task = 'Task 2' THEN hours_logged END) AS Task2_hours, SUM(CASE WHEN task = 'Task 3' THEN hours_logged END) AS Task3_hours FROM time_log GROUP BY employee_name, task;

This query pivots the time log data by task, aggregating the total number of hours logged by employees on different tasks.

Q29

Multiple Choice

Determine the SQL query that uses PIVOT to display the average test scores for students across different subjects.

SQL Code

SELECT student_name,
AVG(CASE WHEN subject = 'Math' THEN score ELSE 0 END) AS Math_avg,
AVG(CASE WHEN subject = 'Science' THEN score ELSE 0 END) AS Science_avg,
AVG(CASE WHEN subject = 'History' THEN score ELSE 0 END) AS History_avg
FROM test_scores
GROUP BY student_name;

SELECT student_name, AVG(CASE WHEN subject = 'Math' THEN score ELSE 0 END) AS Math_avg, AVG(CASE WHEN subject = 'Science' THEN score ELSE 0 END) AS Science_avg, AVG(CASE WHEN subject = 'History' THEN score ELSE 0 END) AS History_avg FROM test_scores GROUP BY student_name; SELECT student_name, subject, score FROM test_scores GROUP BY student_name, subject; SELECT student_name, CASE WHEN subject = 'Math' THEN score END AS Math_avg, CASE WHEN subject = 'Science' THEN score END AS Science_avg, CASE WHEN subject = 'History' THEN score END AS History_avg FROM test_scores;SELECT student_name, AVG(CASE WHEN subject = 'Math' THEN score END) AS Math_avg, AVG(CASE WHEN subject = 'Science' THEN score END) AS Science_avg, AVG(CASE WHEN subject = 'History' THEN score END) AS History_avg FROM test_scores GROUP BY student_name, subject;

This query pivots the test scores data by subject, calculating the average score for each student across different subjects.

Q30

Multiple Choice

Which SQL query uses PIVOT to summarize sales data, showing the total quantity sold per product across different months?

SQL Code

SELECT product_name,
SUM(CASE WHEN month = 'January' THEN quantity ELSE 0 END) AS Jan_quantity,
SUM(CASE WHEN month = 'February' THEN quantity ELSE 0 END) AS Feb_quantity,
SUM(CASE WHEN month = 'March' THEN quantity ELSE 0 END) AS Mar_quantity
FROM sales_data
GROUP BY product_name;

SELECT product_name, SUM(CASE WHEN month = 'January' THEN quantity ELSE 0 END) AS Jan_quantity, SUM(CASE WHEN month = 'February' THEN quantity ELSE 0 END) AS Feb_quantity, SUM(CASE WHEN month = 'March' THEN quantity ELSE 0 END) AS Mar_quantity FROM sales_data GROUP BY product_name; SELECT product_name, month, quantity FROM sales_data GROUP BY product_name, month; SELECT product_name, CASE WHEN month = 'January' THEN quantity END AS Jan_quantity, CASE WHEN month = 'February' THEN quantity END AS Feb_quantity, CASE WHEN month = 'March' THEN quantity END AS Mar_quantity FROM sales_data;SELECT product_name, SUM(CASE WHEN month = 'January' THEN quantity END) AS Jan_quantity, SUM(CASE WHEN month = 'February' THEN quantity END) AS Feb_quantity, SUM(CASE WHEN month = 'March' THEN quantity END) AS Mar_quantity FROM sales_data GROUP BY product_name, month;

This query pivots the sales data by month, showing the total quantity sold for each product across different months.

MySQL Database Quiz Questions