SourCaPlacement OS
Targeted Campus Assessment Prep
Loading SourCa...
Synchronizing placement benchmarks & campus recruitment roadmaps
Targeted Campus Assessment Prep
Loading SourCa...
Synchronizing placement benchmarks & campus recruitment roadmaps
Targeted Campus Assessment Prep
Setting up coding workspace...
Loading problem statement, test cases, and compiler sandbox
| user_id (int) | join_date (date) | favorite_brand (varchar) |
|---|---|---|
| 1 | 2019-01-01 | Lenovo |
| 2 | 2019-02-09 | Samsung |
| 3 | 2019-01-19 | LG |
| order_id (int) | order_date (date) | item_id (int) | buyer_id (int) | seller_id (int) |
|---|---|---|---|---|
| 1 | 2019-08-01 | 4 | 1 | 2 |
| 2 | 2019-08-02 | 2 | 1 | 3 |
| 3 | 2019-08-03 | 3 | 2 | 3 |
| 4 | 2019-08-04 | 1 | 4 | 2 |
| item_id (int) | item_brand (varchar) |
|---|---|
| 1 | Samsung |
| 2 | Lenovo |
| 3 | LG |
| 4 | HP |
Click 'Run & Verify Query' to test your SQL against the sample test fixture.