Scribd
Upload
29 views8 pages

SQLQuerytask 3

The document contains a series of SQL queries designed to analyze customer support data from a database. It includes queries for selecting data, counting tickets by agent, grouping by categories, and creating a view for manager ticket summaries. The queries also involve joining tables to find relationships between agents and their managers.

Uploaded by

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

SQLQuerytask 3

The document contains a series of SQL queries designed to analyze customer support data from a database. It includes queries for selecting data, counting tickets by agent, grouping by categories, and creating a view for manager ticket summaries. The queries also involve joining tables to find relationships between agents and their managers.

Uploaded by

22it95
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

SQL QUERIES TASK 3

1.SELECT TOP (1000) [Unique id]


,[channel_name]
,[category]
,[Sub-category]
,[Customer Remarks]
,[Order_id]
,[order_date_time]
,[Issue_reported at]
,[issue_responded]
,[Survey_response_Date]
,[Customer_City]
,[Product_category]
,[Item_price]
,[connected_handling_time]
,[Agent_name]
,[Supervisor]
,[Manager]
,[Tenure Bucket]
,[Agent Shift]
,[CSAT Score]
FROM [akshitadb].[dbo].[Customer_support_data
(1)]

2.SELECT Agent_name, COUNT(*) AS Ticket_Count


FROM [akshitadb].[dbo].[Customer_support_data
(1)]
GROUP BY Agent_name;
SQL QUERIES TASK 3

3.SELECT COUNT(*) AS Unique_id FROM


[akshitadb].[dbo].[Customer_support_data (1)];

4.SELECT Agent_name, COUNT(*) AS issue_responded


FROM [akshitadb].[dbo].[Customer_support_data
(1)]
GROUP BY Agent_name
ORDER BY issue_responded DESC;
SQL QUERIES TASK 3

5.SELECT category , COUNT(*) AS Count


FROM [akshitadb].[dbo].[Customer_support_data
(1)]
GROUP BY category
ORDER BY Count DESC;
SQL QUERIES TASK 3

6.SELECT
A.[Agent_name],
A.[Manager],
B.[Agent_name] AS Other_Agent,
B.[Manager] AS Other_Manager
FROM [akshitadb].[dbo].[Customer_support_data
(1)] A
INNER JOIN
[akshitadb].[dbo].[Customer_support_data (1)] B
ON A.[Manager] = B.[Manager]
AND A.[Agent_name] <> B.[Agent_name];
SQL QUERIES TASK 3

7.SELECT
A.[Agent_name],
A.[Manager],
B.[Agent_name] AS Colleague
FROM [akshitadb].[dbo].[Customer_support_data
(1)] A
LEFT JOIN
[akshitadb].[dbo].[Customer_support_data (1)] B
ON A.[Manager] = B.[Manager]
AND A.[Agent_name] <> B.[Agent_name];
SQL QUERIES TASK 3

8.SELECT
B.[Agent_name],
B.[Manager],
A.[Agent_name] AS Colleague
FROM [akshitadb].[dbo].[Customer_support_data
(1)] A
RIGHT JOIN
[akshitadb].[dbo].[Customer_support_data (1)] B
ON A.[Manager] = B.[Manager]
AND A.[Agent_name] <> B.[Agent_name];
SQL QUERIES TASK 3

9.SELECT *
FROM [akshitadb].[dbo].[Customer_support_data
(1)]
WHERE [CSAT Score] = (
SELECT MAX([CSAT Score])
FROM
[akshitadb].[dbo].[Customer_support_data (1)]
);

10.CREATE VIEW Manager_Ticket_Summary AS


SELECT
[Manager],
SQL QUERIES TASK 3
COUNT(*) AS Total_Tickets
FROM [akshitadb].[dbo].[Customer_support_data
(1)]
GROUP BY [Manager];

SELECT * FROM Manager_Ticket_Summary;

You might also like