30-Days-DSA-Challenge
30-Days-DSA-Challenge copied to clipboard
iamdestinychild
1581. Customer Who Visited but Did Not Make Any Transactions
Description
1581. 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.
DSA Problem
Q. 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.
I want to solve this leetCode SQL query can you please assign me and label this as @hacktoberfest
