1581. Customer Who Visited but Did Not Make Any Transactions LeetCode Solution
In this guide, you will get 1581. Customer Who Visited but Did Not Make Any Transactions LeetCode Solution with the best time and space complexity. The solution to Customer Who Visited but Did Not Make Any Transactions problem is provided in various programming languages like C++, Java, and Python. This will be helpful for you if you are preparing for placements, hackathons, interviews, or practice purposes. The solutions provided here are very easy to follow and include detailed explanations.
Problem Statement of Customer Who Visited but Did Not Make Any Transactions
Table: Visits
+————-+———+
| Column Name | Type |
+————-+———+
| visit_id | int |
| customer_id | int |
+————-+———+
visit_id is the column with unique values for this table.
This table contains information about the customers who visited the mall.
Table: Transactions
+—————-+———+
| Column Name | Type |
+—————-+———+
| transaction_id | int |
| visit_id | int |
| amount | int |
+—————-+———+
transaction_id is column with unique values for this table.
This table contains information about the transactions made during the visit_id.
Write a solution to find the IDs of the users who visited without making any transactions and the number of times they made these types of visits.
Return the result table sorted in any order.
The result format is in the following example.
1581. Customer Who Visited but Did Not Make Any Transactions LeetCode Solution in C++
SELECT
Visits.customer_id,
COUNT(Visits.visit_id) AS count_no_trans
FROM Visits
LEFT JOIN Transactions
USING (visit_id)
WHERE Transactions.transaction_id IS NULL
GROUP BY 1; /* code provided by PROGIEZ */
1581. Customer Who Visited but Did Not Make Any Transactions LeetCode Solution in Java
N/A // code provided by PROGIEZ
1581. Customer Who Visited but Did Not Make Any Transactions LeetCode Solution in Python
