Watch 10 video solutions for Drop Type 1 Orders for Customers With Type 0 Orders, a medium level problem involving Database. This walkthrough by Dave Burji has 596,394 views views. Want to try solving it yourself? Practice on FleetCode or read the detailed text solution.
Table: Orders
+-------------+------+ | Column Name | Type | +-------------+------+ | order_id | int | | customer_id | int | | order_type | int | +-------------+------+ order_id is the column with unique values for this table. Each row of this table indicates the ID of an order, the ID of the customer who ordered it, and the order type. The orders could be of type 0 or type 1.
Write a solution to report all the orders based on the following criteria:
0, do not report any order of type 1 from that customer.Return the result table in any order.
The result format is in the following example.
Example 1:
Input: Orders table: +----------+-------------+------------+ | order_id | customer_id | order_type | +----------+-------------+------------+ | 1 | 1 | 0 | | 2 | 1 | 0 | | 11 | 2 | 0 | | 12 | 2 | 1 | | 21 | 3 | 1 | | 22 | 3 | 0 | | 31 | 4 | 1 | | 32 | 4 | 1 | +----------+-------------+------------+ Output: +----------+-------------+------------+ | order_id | customer_id | order_type | +----------+-------------+------------+ | 31 | 4 | 1 | | 32 | 4 | 1 | | 1 | 1 | 0 | | 2 | 1 | 0 | | 11 | 2 | 0 | | 22 | 3 | 0 | +----------+-------------+------------+ Explanation: Customer 1 has two orders of type 0. We return both of them. Customer 2 has one order of type 0 and one order of type 1. We only return the order of type 0. Customer 3 has one order of type 0 and one order of type 1. We only return the order of type 0. Customer 4 has two orders of type 1. We return both of them.